Select Query with left outer join problem

Question

0.00/5 (No votes)

See more:

Hi, Iam using VS2010. DataBase-MSAccess2010. While I use the multiple Left Outer Join Query,
Iam facing trouble.

My Query

SQL

Select dc.*, it.itm_description, pt.pty_name 
from dcmst dc 
left outer join itemmst it on dc.itm_code = it.itm_code 
left outer join partymst pt on dc.del_pty_code = pt.pty_code

Receiving the error
OLEDB Exception was unhandled
Syntax error ( missing operator) in query expression 'dc.itm_code=it.itm_code left outer join partymst pt on dc.del_pty_code=pt.pty_cod'.
Really I can't understand my mistake...Does anybody can point my mistake..

Thanks for the helps

Posted 14-Jun-14 22:53pm

Paramu1973

Updated 14-Jun-14 22:58pm

Kornfeld Eliyahu Peter

v3

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Accepted Answer · 2014-06-14T22:59:00

Solution 1

Learn from someone who made the same mistake: multiple-left-joins-in-ms-access.html[^]

Posted 14-Jun-14 22:59pm

Peter Leow

Comments

Nelek 15-Jun-14 6:18am

OP thanked you in a non-solution

Peter Leow 15-Jun-14 6:23am

Thanks Nelek.

DamithSL · Accepted Answer · 2014-06-14T23:27:00

Solution 3

As peter's answer you need additional pair(s) of parentheses but still you will get syntax error.
Use a LEFT JOIN operation to create a left outer join

SQL

Select dc.*, it.itm_description, pt.pty_name 
FROM (dcmst dc LEFT JOIN itemmst it on dc.itm_code = it.itm_code) LEFT JOIN partymst pt on dc.del_pty_code = pt.pty_code

Posted 14-Jun-14 23:27pm

DamithSL

Comments

Nelek 15-Jun-14 6:18am

OP thanked you in a non-solution

Select Query with left outer join problem

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

Select Query with left outer join problem

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us