Perhaps you want the ON syntax SELECT x, y, z FROM table t, lookupA a, lookupB b WHERE t.aID = a.aID AND t.bID = b.bID
is equivalent to: SELECT x, y, z FROM table t INNER JOIN lookupA a ON t.aID = a.aID INNER JOIN lookupB b ON t.bID = b.bID If you were to do: SELECT x, y, z FROM table t INNER JOIN lookupA a USING(aID) INNER JOIN lookupB b USING(bID) that would be equivalent to SELECT x, y, z FROM table t INNER JOIN lookupA a ON t.aID = a.aID INNER JOIN lookupB b ON a.bID = b.bID On 9/29/07, Chris W <[EMAIL PROTECTED]> wrote: > I often find that I have more than one column in a tale that is an > integer ID used to join to a lookup table. If there is only one Join to > do it is to do something like this.... > > SELECT t.data, l.group > FROM table t JOIN lookuptable l USING (groupID) > WHERE whatever > > however if I need to join more than one that syntax wont work because > the second join will be trying to join to the first lookup table no the > main table. Is there a way around this or do I need to just do joins > using this syntax.... > SELECT x, y, z > FROM table t, lookupA la, lookupB lb > WHERE t.aID = a.aID AND t.bID = b.bID > > > -- > Chris W > KE5GIX > > "Protect your digital freedom and privacy, eliminate DRM, > learn more at http://www.defectivebydesign.org/what_is_drm"; > > Gift Giving Made Easy > Get the gifts you want & > give the gifts they want > One stop wish list for any gift, > from anywhere, for any occasion! > http://thewishzone.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Rob Wultsch (480)223-2566 [EMAIL PROTECTED] (email/google im) wultsch (aim) [EMAIL PROTECTED] (msn) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
