> Can I check 3 different tables at the same time like in this > query? Is this logic ok? > > <cfquery name="loginCheck" datasource="#APPLICATION.dsn#"> > SELECT c.clubId, > c.shortName, > cM.clubMemberId, > cLM.clubId, > cLM.clubMemberId, > cM.loginName, > cM.password_2 > FROM club as c, > clubMember as cM, > clubLinkMember as cLM > WHERE c.shortName = #URL.shortName# > AND cM.loginName = '#FORM.loginName#' > AND cM.password_2 = '#FORM.password#' > AND cLM.clubMemberId = cM.clubMemberId > AND cLM.clubId = cM.clubId > </cfquery>
No, that logic contains a cartesian product. You have no explicit join condition between club and either of the other two tables. You also have two join conditions between clubMember and clubLinkMember, which may be correct, but probably isn't in your case. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
