macromedia.coldfusion.database_access
[Top] [All Lists]

3 table join

Subject: 3 table join
From: "weezerboy" <webforumsuser@xxxxxxxxxxxxxx>
Date: Thu, 21 Feb 2008 02:18:05 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

I have 3 related tables named

 NAMEINFOF
 FUNCTIONSF 
 RESTAURANTF 

 Each person has 1 row in each table

 1 row in NAMEINFOF
 1 row in FUNCTIONSF 
 1 row in RESTAURANTF 


 There is a column for each record in each table named   conference_userid      
   that relates the tables to each other.

 For example PAT has a conference_userid of 66 and PAT has a row in each of the 
3 tables.

 I need to output the rows for Pat from each of the 3 tables in 1 query.

 I get this error

 [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft 
Access Driver] Too few parameters. Expected 2. 




<Prev in Thread] Current Thread [Next in Thread>