Why this query is not working

[Guest]

SELECT * FROM tblUserDetails
LEFT OUTER JOIN tblDesignation ON tblDesignation.DesignationID =
tblUserDetails.DesignationID
LEFT OUTER JOIN tblKnow ON tblKnow.KnowID = tblUserDetails.KnowID
LEFT OUTER JOIN tblType ON tblType.TypeID = tblUserDetails.TypeID
LEFT OUTER JOIN tblCountry ON tblCountry.CountryID = tblUserDetails.CountryID

I had also created Relationship between the table in Microsoft Access.

It is working for first LEFT OUTER JOIN operation (It successfully joins two
tables)
e.g
SELECT * FROM tblUserDetails
LEFT OUTER JOIN tblDesignation ON tblDesignation.DesignationID =
tblUserDetails.DesignationID

else it is gives error. Why?

Waiting for quick reply

Thanks in advance
Hemant Kulkarni

 

[Brian]

SELECT * FROM tblUserDetails
LEFT OUTER JOIN tblDesignation ON tblDesignation.DesignationID =
tblUserDetails.DesignationID
LEFT OUTER JOIN tblKnow ON tblKnow.KnowID = tblUserDetails.KnowID
LEFT OUTER JOIN tblType ON tblType.TypeID = tblUserDetails.TypeID
LEFT OUTER JOIN tblCountry ON tblCountry.CountryID = tblUserDetails.CountryID

I had also created Relationship between the table in Microsoft Access.

It is working for first LEFT OUTER JOIN operation (It successfully joins two
tables)
e.g
SELECT * FROM tblUserDetails
LEFT OUTER JOIN tblDesignation ON tblDesignation.DesignationID =
tblUserDetails.DesignationID

else it is gives error. Why?

Waiting for quick reply

Thanks in advance
Hemant Kulkarni

You're gonna need some parentheses around the joins, maybe like this:

SELECT * FROM ((((tblUserDetails
LEFT OUTER JOIN tblDesignation ON tblDesignation.DesignationID =
tblUserDetails.DesignationID)
LEFT OUTER JOIN tblKnow ON tblKnow.KnowID = tblUserDetails.KnowID)
LEFT OUTER JOIN tblType ON tblType.TypeID = tblUserDetails.TypeID)
LEFT OUTER JOIN tblCountry ON tblCountry.CountryID =
tblUserDetails.CountryID)

 

[Guest]

Thank you Brian for quick and correct resposnse, Much Appericated