Hi-<BR><BR>I have a query in an asp page and I'm trying to find out how to group results together.<BR><BR>For example - The query will ask for all 'jobs' and 'projects' for a customer. 'Projects' are items that are parts of 'jobs'. So, my query will bring back a listing of 'jobs' and each of it's related 'projects'. How can I loop through the results making sure that each job lists its related projects? The relationship is the 'job_id'.