hi all

not sure if nested query is the right term or not. basically what i'd
like to do is this...

i have a table called SOFTWARE which lists customer id's and software
id's for all the software that our customers have installed. what i'd
like to do is for each customer, select the software they have
installed in different columns rather than customer by customer...

so rather than do SELECT * FROM SOFTWARE WHERE "CustomerID" = blah
and it list
Windows XP
Office XP
...

i'd like to have it like this
Customer 1, Windows XP, Office XP
Customer 2, Some other software

is this possible?

TIA