On Fri, 02 Aug 2002 16:09:33 +1200, you wrote: >WHERE (Viewed.UserID = 1) > and (Viewed.LastViewedDate < Items.LastModified) > or (Viewed.LastViewedDate IS NULL) > >How about that?
Hi Matthew. That's close. That gives me line 2 and 5, but not 4. Line 4 exists in the table because user 2 has read it, and then the query limits it to user 1 only, and it drops out. -- Steve Duff ebay/bidville: ndsman ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
