On Thu, 01 Aug 2002 23:09:28 -0500, you wrote: >Looong list of things going on, but try this query to see what you get! > >SELECT i.ItemName >FROM Users u, LastViewed lv, Items i >WHERE i.ItemId = lv.ItemId >AND i.itemLastModified > lv.LastViewedDate >AND lv.UserID = '1' > >Paul Giesenhagen >QuillDesign
Hi Paul. I get a long list of item 2 with that, presumably because the users table isn't referenced at all. Killing the users u part, it returns just line 2, and not the needed 4 and 5. -- Steve Duff ebay/bidville: ndsman ______________________________________________________________________ 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
