Errol Farro
asked on
Problem joining 3 tables
When I try joining 3 tables, I get the following message;
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'm.mstDeptId = d.dptId LEFT OUTER JOIN branch b ON m.mstBranchId = b.brcId'.
My query looks like this;
SELECT m.mstFname, m.mstLname, {fn LEFT(m.mstLname, 1)} AS Initial, m.mstPhone, d.dptName, b.brcName
FROM master m
LEFT OUTER JOIN department d
ON m.mstDeptId = d.dptId
LEFT OUTER JOIN branch b
ON m.mstBranchId = b.brcId
ORDER BY m.mstLname
What am I doing wrong? I'm currently using Coldusion MX 6.1.
Thanks,
Errol Farro
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'm.mstDeptId = d.dptId LEFT OUTER JOIN branch b ON m.mstBranchId = b.brcId'.
My query looks like this;
SELECT m.mstFname, m.mstLname, {fn LEFT(m.mstLname, 1)} AS Initial, m.mstPhone, d.dptName, b.brcName
FROM master m
LEFT OUTER JOIN department d
ON m.mstDeptId = d.dptId
LEFT OUTER JOIN branch b
ON m.mstBranchId = b.brcId
ORDER BY m.mstLname
What am I doing wrong? I'm currently using Coldusion MX 6.1.
Thanks,
Errol Farro
ASKER
No, I already tried it as you are recommending but I get the same error message.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a million. This has solved my problem.
Best Regards,
Errol Farro
Aruba
Best Regards,
Errol Farro
Aruba
This may sound stupid but whenever I have this problem I do this....and works for me... please try and let me tknow...
SELECT m.mstFname, m.mstLname, {fn LEFT(m.mstLname, 1)} AS Initial, m.mstPhone, d.dptName, b.brcName
FROM master m
LEFT OUTER JOIN department d
ON (m.mstDeptId = d.dptId)
LEFT OUTER JOIN branch b
ON (m.mstBranchId = b.brcId)
ORDER BY m.mstLname