On Fri, 02 Aug 2002 15:17:27 +0200, you wrote: >I hope your database understands the join syntax: > >SELECT > Items.ItemID, > Items.Name, > Items.LastModified, > Viewed.UserID, > Viewed.LastViewedDate >FROM > Items LEFT OUTER JOIN Viewed > ON (Items.ItemID = Viewed.ItemID > AND Viewed.UserID = 1) >WHERE > Viewed.LastViewedDate < Items.ItemLastModified > OR > Viewed.LastViewedDate IS NULL >ORDER BY > Items.ItemID > >Jochem
*ding ding ding* We have a winner! Thanks Jochem. I'm not sure I completely understand it, but it's functioning perfectly. All my attempts and most here were adjusting the where clause, the key seems to be the From clause in yours. -- Steve Duff ebay/bidville: ndsman ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
