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

pinaldave

hello,
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

Errol Farro

ASKER

No, I already tried it as you are recommending but I get the same error message.

ASKER CERTIFIED SOLUTION

mrichmon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Errol Farro

ASKER

Thanks a million. This has solved my problem.
Best Regards,

Errol Farro
Aruba