> I wasn't disagreeing with you - I'd like to know which is quicker, and if I > have 5 mins I'll test it, but I don't, so perhaps someone else can... > ~lol~ ok....
I thought you'd run the query and got the sub-queries as being quicker, so I couldn't be bothered to check it out as I'm busy too! ;o) I'll have to have a look see if I've got some suitably large datasets with proper indexes etc. on them that I can do sub-queries and JOINs and have a test, later...... -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
