4访问表 - 如何使用左连接选择查询？ [英] 4 Access Tables - How to have a Select Query with Left Join ?

问题描述

Iam使用vs2010，Access 2010.我有4个表的Access DataBase。我希望根据需要从所有其他表中选择一个查询...是否可以？



感谢帮助



我的查询： -

===========

选择iv。*， pt.pty_name，cm.commodity，it.itm_description，cy.company_name 来自（invoicetbl iv left  join  partytbl pt on iv.pty_code = pt.pty_code left  join 商品cm在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 其中 Len（Trim（iv.inv_year））> 0订单由iv.invoice_no，iv.line_no 

执行时上面的查询收到错误，如

语法错误（缺少 operator ） in 查询表达式iv.pty_code = pt.pty_code 
左加入商品cm在iv.commodity_id = cm.commodity_id left  join  itemtbl it on iv.itm_code = it.itm_code 

再次感谢

解决方案

删除括号。

 选择 iv。*，pt.pty_name，cm.commodity，it.itm_description，cy.company_name 来自 invoicetbl iv  left   join  partytbl pt  on  iv.pty_code = pt.pty_code  left   join 商品cm   iv.commodity_id = cm.commodity_id  left   join  itemtbl it  on  iv.itm_code = it.i tm_code  left   join  companytbl cy  on  .. 

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 :-
===========

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

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

解决方案

Remove the brackets.

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 ...

这篇关于4访问表 - 如何使用左连接选择查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！