I'm with you on this, Dave. I think the existence of the join condition eliminates the Cartesian cross-product result.
Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 1:16 PM To: CF-Talk Subject: RE: WOT: Access SQL Question - Round 2 > In Access, if you use "FROM issues, owners WHERE issues.owner > = users.name" you're doing a cartesian join, which produces > every possible combination of the two tables. An inner join, > on the other hand, will return only the rows that match your > join condition. Admittedly, I don't use Access that often, but that hasn't been my experience. My experience has been that Access will treat non-ANSI joins as described above as inner joins, at least with regard to passthrough SQL statements from CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
