Im doing it in sql server 2005...management studio express
I used the nested subquery method in ms access before and it was slow.
You need to post ddl ( create tables scripts), sample data (insert statements) and desired output based on your sample data.
I have no idea what the ddl is.
I posted the sample results and the desired results...
I'm not sure what else I need to post...
Sorry if i seem to be hard headed...