On Fri, 02 Aug 2002 00:23:15 -0400, you wrote: >What about something like this. (note the placement of the () with the >AND/OR)... > >Justin > >SELECT Items.ItemID, Items.Name, Items.LastModified, > Viewed.UserID, Viewed.LastViewedDate >FROM Items LEFT OUTER JOIN Viewed > ON Items.ItemID = Viewed.ItemID >WHERE (Viewed.UserID = 1 > and Viewed.LastViewedDate < Items.LastModified) > or Viewed.UserID is null >ORDER BY Items.ItemID
Hi Justin. Same result as Matthew's attempt, it gets 2 and 5, but not 4 because of User 2. Maybe it can't be done? -- 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
