can we sub list record..?

that is;

like this:

name 1-----product 1-------qty1
------------product 2-------qty2
------------product 3-------qty 3
name 2-----product 1-------qty 4
------------product 5-------qty 5

like this.. i've put lines to properly display tabs..

by which method we can do that.. can we do this using join..?

thanks in advance...

It can be done, but the method depends on your tools. Some DBMSs can do this in pure SQL, but the syntax varies. More usually it is done in the reporting tool.

we want it in sql query.. not any additional tool.. our head told it can be done..

Whose SQL are you using? Oracle, Microsoft, IBM. MySQL, ...?