Hey that is some good info, Ive always locked the queries when doing that (luckily not high traffic site), this leads me to another query Ive been putting on the back burner.
Here is the working query, shortened for the example: SELECT a.SalesMan,a.CustomerName,b.Entry_Comments,b.Entry_Date FROM MyMaster a LEFT OUTER JOIN MyDetail b ON a.id = b.id WHERE blah ORDER BY blah This works fine and I get all my detail reocrds for each master. Now I need to be able to select only a single most recent b.Entry_Date. MAX(b.Entry_D) requires I group the entire query. Whats a good way to accomlish this? Thanks,Adrian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
