Hi All,

I am trying to retrieve data from 3 tables where the ID field is
common in all 3 tables.

When I write a 2-table left outer join everything works
perfectly:

Code:

strSQL = ("SELECT * FROM tblform LEFT OUTER JOIN tblDiscussion ONtblform.CCF = tblDiscussion.CCFID WHERE tblform.ccf=" &Request.QueryString("qryID") & " ")

When I try to add another table I receive either one of the following errors:

Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression .

OR

Microsoft VBScript compilation (0x800A03EE)
Expected ')'

I have tried several different variations including:

1) Code:

("SELECT * FROM tblform LEFT OUTER JOIN tblDiscussion ONtblform.CCF = tblDiscussion.CCFID LEFT OUTER JOIN tblUpload ONtblform.CCF = tblUpload.CCFID WHERE tblform.ccf=" &Request.QueryString("qryID") & " ")

2) Code:

("SELECT * FROM tblform (LEFT OUTER JOIN tblDiscussion ONtblform.CCF = tblDiscussion.CCFID) LEFT OUTER JOIN tblUpload ONtblform.CCF = tblUpload.CCFID WHERE tblform.ccf=" &Request.QueryString("qryID") & " ")

3) Code:

("SELECT * FROM tblform LEFT OUTER JOIN tblDiscussion ONtblform.CCF = tblDiscussion.CCFID WHERE tblform.ccf=" &Request.QueryString("qryID") & " LEFT OUTER JOIN tblUpload ONtblform.CCF = tblUpload.CCFID WHERE tblform.ccf=" &Request.QueryString("qryID") & " ")

After 4 days I still cannot get this to successfully work.
Any ideas please?
Thanks!

you need to nest the brackets

"SELECT * FROM (tblform LEFT OUTER JOIN tblDiscussion ON tblform.CCF = tblDiscussion.CCFID (LEFT OUTER JOIN tblUpload ON tblform.CCF = tblUpload.CCFID WHERE tblform.ccf=" &Request.QueryString("qryID") & " "))

Looks about right I think

you should also cast the querystring parameter into the correct type for the field.

1/ because a querystring value will be a string type and ID fields could be a numeric type.

2/ because using untested querystring values can leave your queries wide open to injection attacks.