List:General Discussion« Previous MessageNext Message »
From:Steffan A. Cline Date:June 30 2006 2:30pm
Subject:Multiple joins
View as plain text  
What am I missing here?

select m.*, d.discussion, d.discussion_id, u.user_id, t.topic_id
from forums_messages
left join forums_members m, forums_discussions d, users u, forums_topics t
on m.topic_id = t.topic_id, t.discussion_id = d.discussion_id
where m.topic_id = "1";

Is it legal to do multiple joins like this?




Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 5 7 9 . 4 2 3 0 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
                                  Lasso Partner Alliance Member
---------------------------------------------------------------



Thread
Multiple joinsSteffan A. Cline30 Jun
  • Re: Multiple joinsGerald L. Clark30 Jun
    • Re: Multiple joinsSteffan A. Cline30 Jun
  • Re: Multiple joinsBrent Baisley30 Jun