|
-
September 17th, 2001, 12:51 AM
#1
SQL - Inner Join
i had 3 tables that are linked together by several primary keys.
-table1 has A and B as primary key
-table2 has A, B, C and D as primary key
-table3 has A, B and C as primary key
-table1 is linked to table2 by A and B
-table2 is linked to table3 by A, B, C and D
my SQL inner join statement is :
"SELECT * from " & _
"(table1 INNER JOIN " & _
"(table2 INNER JOIN table3 " & _
"ON table2.A=table3.A " & _
"and table2.B=table3.B " & _
"and table2.C=table3.C " & _
"and table2.D=table3.D) " & _
"ON table1.A=table2.A " & _
"and table1.B=table2.B)"
Is this SQL statement true?
Prompt reply is much appreciated.
Thank You.
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
|