JOIN Multiple Tables

[rn5a]

I am trying to retrieve records from 7 tables for which I am using the
following SQL query:

SELECT
U.UID,C.CID,C.Category,I.IID,I.Institute,L.LID,L.Location,Q.QID,Q.Qualification,S.SID,S.Specialization,R.ExpYears,R.ExpMonths,R.Skills
FROM (Resume AS R INNER JOIN Users AS U ON U.UID=R.UID) INNER JOIN
Category AS C ON R.CID=C.CID INNER JOIN Institute AS I ON R.IID=C.IID
INNER JOIN Location AS L ON R.LID=L.LID INNER JOIN Qualification AS Q
ON R.QID=Q.QID INNER JOIN Specialization AS S ON R.SID=S.SID WHERE
R.UID=2

but the above query generates the following error:

Syntax error (missing operator) in query expression 'R.CID=C.CID INNER
JOIN Institute AS I ON R.IID=C.IID INNER JOIN Location AS L ON
R.LID=L.LID INNER JOIN Qualification AS Q ON R.QID=Q.QID INNER JOIN
Specialization AS S ON R.SID=S.SID'.

Can someone please point out what am I missing in the above SQL query?

Thanks

 

[James A. Fortune]

I am trying to retrieve records from 7 tables for which I am using the
following SQL query:

SELECT
U.UID,C.CID,C.Category,I.IID,I.Institute,L.LID,L.Location,Q.QID,Q.Qualification,S.SID,S.Specialization,R.ExpYears,R.ExpMonths,R.Skills
FROM (Resume AS R INNER JOIN Users AS U ON U.UID=R.UID) INNER JOIN
Category AS C ON R.CID=C.CID INNER JOIN Institute AS I ON R.IID=C.IID
INNER JOIN Location AS L ON R.LID=L.LID INNER JOIN Qualification AS Q
ON R.QID=Q.QID INNER JOIN Specialization AS S ON R.SID=S.SID WHERE
R.UID=2

but the above query generates the following error:

Syntax error (missing operator) in query expression 'R.CID=C.CID INNER
JOIN Institute AS I ON R.IID=C.IID INNER JOIN Location AS L ON
R.LID=L.LID INNER JOIN Qualification AS Q ON R.QID=Q.QID INNER JOIN
Specialization AS S ON R.SID=S.SID'.

Can someone please point out what am I missing in the above SQL query?

Thanks

Try:

SELECT
U.UID,C.CID,C.Category,I.IID,I.Institute,L.LID,L.Location,Q.QID,Q.Qualification,S.SID,S.Specialization,R.ExpYears,R.ExpMonths,R.Skills
FROM (((((Resume AS R INNER JOIN Users AS U ON U.UID=R.UID) INNER JOIN
Category AS C ON R.CID=C.CID) INNER JOIN Institute AS I ON R.IID=I.IID)
INNER JOIN Location AS L ON R.LID=L.LID) INNER JOIN Qualification AS Q
ON R.QID=Q.QID) INNER JOIN Specialization AS S ON R.SID=S.SID;

I added parentheses and used I.IID for the Institute JOIN. It worked
for the single test case I tried.

James A. Fortune
(e-mail address removed)