> I'm know any anything about inner/outer joins - how is > using an inner join different from using pk=fk, and why > would you want to use it in this case?
An inner join is reasonably similar to using pk=fk in a where clause. I'm not sure what the internal differences are, re: performance, etc. An outer join produces a query wherein data from table 1 is required and data from table 2 is optional, i.e. "find all issues associated with user x" wherein you want to retreive data from the users table and zero or more associated records from the issues table. With an inner join or a typical pk=fk where clause, no data is returned from the users table if there are no issues associated with the user. In this particular case he probably didn't want an outer join, although it's possible an inner join might improve performance over the where clause, but again that's just conjecture. hth s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > Thanks, > 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: Dina Hess [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 17, 2003 12:31 PM > To: CF-Talk > Subject: Re: WOT: Access SQL Question - Round 2 > Matthew and Isaac have provided you with two excellent > workarounds. I > just have one thing to add. > The "where pk=fk" syntax doesn't produce an inner join in > Access. > Instead use "from issues i inner join users u on i.owner = > u.name". > Too bad you have to go thru all of this...a normalized > database schema > would've prevented this problem...which you probably > haven't seen the > last of... :) > ~Dina > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > 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/uns > ubscribe.cfm?user=633.558.4 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
