4访问表 - 如何使用左连接选择查询? [英] 4 Access Tables - How to have a Select Query with Left Join ?
本文介绍了4访问表 - 如何使用左连接选择查询?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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屋!
查看全文