4 Access Tables - How to have a Select Query with Left Join ?

Question

1.00/5 (1 vote)

See more:

Hi, Iam using vs2010, Access 2010. I have Access DataBase with 4 Tables. I wish to have a select query from all other tables as required...Is it possible?

Thanks For The Helps

My Query :-
===========

C#

Select iv.*,pt.pty_name,cm.commodity,it.itm_description,cy.company_name from (invoicetbl iv left join partytbl pt on iv.pty_code=pt.pty_code left join commodity cm on iv.commodity_id=cm.commodity_id left join itemtbl it on iv.itm_code=it.itm_code) left join companytbl cy on iv.company_id=cy.company_id where Len(Trim(iv.inv_year))>0 order by iv.invoice_no,iv.line_no

When I execute the above query receiving the error like

C#

Syntax error (missing operator) in query expression iv.pty_code=pt.pty_code
 left join commodity cm on iv.commodity_id=cm.commodity_id left join itemtbl it on iv.itm_code=it.itm_code

Thanks Again

Posted 9-Aug-14 5:44am

Paramu1973

Updated 9-Aug-14 6:27am

v2

Add a Solution

Comments

OriginalGriff 9-Aug-14 11:48am

"Is it possible?"
No idea.
What happens when you try it?

Remember we can't see your screen, access your HDD, or read your mind - so we have no idea what table contains what, and how they interrelate. So working out what your query does is pretty much impossible - particularly since we have no idea what you are expecting or getting!

Use the "Improve question" widget to edit your question and provide better information.

Paramu1973 9-Aug-14 12:23pm

Getting the Error like Syntax Error (missing operator) in query operator iv.pty_code=pt.pty_code left join commodity cm on iv.commodity_id=cm.commodity_id left join itemtbl it on iv.itm_code=it.itm_cod.
Thanks

1 solution

Add a Solution

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

OriginalGriff · Answer 1 · 2014-08-09T10:48:00

Solution 1

Remove the brackets.

SQL

Select iv.*,pt.pty_name,cm.commodity,it.itm_description,cy.company_name from invoicetbl iv left join partytbl pt on iv.pty_code=pt.pty_code left join commodity cm on iv.commodity_id=cm.commodity_id left join itemtbl it on iv.itm_code=it.itm_code left join companytbl cy on ...

Posted 9-Aug-14 10:48am

OriginalGriff

Comments

Paramu1973 9-Aug-14 21:39pm

Receiving the same error like
Syntax error (missing operator) in query expression iv.pty_code=pt.pty_code
left join commodity cm on iv.commodity_id=cm.commodity_id left join itemtbl it on iv.itm_code=it.itm_code) left join companytbl cy on iv.company_id=cy.company_i.
Thanks Again

4 Access Tables - How to have a Select Query with Left Join ?

1 solution

Solution 1

Add your solution here

Preview 0

4 Access Tables - How to have a Select Query with Left Join ?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us