SQl INNER JOIN ON 5 tables
-
select * from TABLE1 A INNER JOIN TABLE2 B ON A.STUDENT_ID = B.STUDENT_ID INNER JOIN TABLE3 C ON A.CLASS_ID = C.CLASS_ID INNER JOIN TABLE4 E ON A.FORM_ID = E.FORM_ID, TABLE5 D INNER JOIN E On D.SCHOOL_ID = E.SCHOOL I want to use TABLE1 A to inner join on TABLE2 B, TABLE3 C, TABLE4 E and the TALBE4 E inner join on TABLE5 D. But I get an error "Invalid object name 'E'." Thanks for helping
-
select * from TABLE1 A INNER JOIN TABLE2 B ON A.STUDENT_ID = B.STUDENT_ID INNER JOIN TABLE3 C ON A.CLASS_ID = C.CLASS_ID INNER JOIN TABLE4 E ON A.FORM_ID = E.FORM_ID, TABLE5 D INNER JOIN E On D.SCHOOL_ID = E.SCHOOL I want to use TABLE1 A to inner join on TABLE2 B, TABLE3 C, TABLE4 E and the TALBE4 E inner join on TABLE5 D. But I get an error "Invalid object name 'E'." Thanks for helping
Oh. I get the answer la. It should be select * from TABLE1 A INNER JOIN TABLE2 B ON A.STUDENT_ID = B.STUDENT_ID INNER JOIN TABLE3 C ON A.CLASS_ID = C.CLASS_ID INNER JOIN TABLE4 E ON A.FORM_ID = E.FORM_ID INNER JOIN TABLE5 D On D.SCHOOL_ID = E.SCHOOL Thanks