Isnt that statement a pile of mollases to run? Guarrantied to choke the DB to death? Nowadays I avoid SQL like the plague but back when I was programming the idea was striped queries. It always seemed faster to get a single result from an indexed table and use that as a param to get the next result. As compared to joins as noted below a 486 would just choke with all cpu and memory full. Did all that change with faster hardware? I still think it would be faster to scan 10 individual tables than scan 10 joined tables.