| 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> |
|---|---|---|
| ||
| Previous by Date: | Re: Outer join/inner join, maslinc |
|---|---|
| Next by Date: | ERROR! -- (50003) optimizer ran out of memory before generating execution plan, vkunirs |
| Previous by Thread: | Date Time Stamping issue, WAK123 |
| Next by Thread: | Re: 3 table join, vkunirs |
| Indexes: | [Date] [Thread] [Top] [All Lists] |