|
-
Feb 19th, 2000, 10:37 PM
#1
Thread Starter
Member
Help with SQL Statement
No SQL genius here but I thought I was doing something simple. I am trying to INNER JOIN 3 tables. I got 2 tables to work, but the third dies and gives me (Syntax Error) Missing Operator. Here is what I have any help is greatly appreciated.
This Works:
SELECT Field1, Field2, Field3 FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID
This Does Not:
SELECT Field1, Field2, Field3 FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID INNER JOIN Table3 ON Table1.ID = Table3.ID
Is this possible?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|