Re: 3 table join

["weezerboy" <webforumsuser@xxxxxxxxxxxxxx>]

Here is the code..seems like this should work!!!
 I have created relationships for the 3 tables on conference_userid

 <cfquery name="conferencelist" datasource="conferences" dbtype="ODBC">
  select n.* from NAMEINFOF n 
  LEFT JOIN FUNCTIONSF f on n.conference_userid=f.conference_userid 
  LEFT JOIN RESTAURANTF r on n.conference_userid=r.conference_userid where 
n.conference_userid=1 
 </cfquery>

 Here is the error message

 Error Executing Database Query.  
 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft 
Access Driver] Syntax error (missing operator) in query expression 
&apos;n.conference_userid=f.conference_userid LEFT JOIN RESTAURANTF r on 
n.conference_userid=r.conference_userid&apos;.