sql := 'select ho_device.*,license.*,ho_info.*,manufactuter.*,mf_device.*,dev_type.dev_name from ho_device,license,ho_info,manufactuter,mf_device,dev_type where ho_device.dev_code = license.dev_code and ho_info.code = ho_device.code ';
sql := sql + 'and manufactuter.code = ho_device.mf_code and mf_device.dev_code = ho_device.mf_devcode and dev_type.dev_num = ho_device.dev_type';对6个表进行的联合查询,如何使用 inner join写出来?
sql := sql + 'and manufactuter.code = ho_device.mf_code and mf_device.dev_code = ho_device.mf_devcode and dev_type.dev_num = ho_device.dev_type';对6个表进行的联合查询,如何使用 inner join写出来?
解决方案 »
- [Error] WARNING. Duplicate resource(s):请教!!!!
- 无窗口程序如何响应键盘?xp下
- dll 导入导出问题,源码全给出来,帮忙解一下
- 简单的异常,谢谢指教??
- 怎样将DBGrid的下部滚动条复位到左侧?(马上给分)
- 有关2000下CTRL+DEL+ALT的屏蔽
- 哪位前辈 能提供写好现成加解密的函数
- 好像大家都用FASTreport,请问,哪里有下载正式中文版的地方?
- 用delphi开发OCX控件的问题?
- 关于windows xp的问题?
- 非常火急的问题求助
- 讓得delphi的ADOCommand的CommandText是可以一次執行多個SQL語句的,如selet .... delete ....兩條語句,但在delphi7下卻測試不通過。
from ho_device
inner join license on ho_device.dev_code = license.dev_code
inner join ho_info on ho_info.code = ho_device.code
inner join manufactuter on manufactuter.code = ho_device.mf_code
inner join mf_device on mf_device.dev_code = ho_device.mf_devcode
inner join dev_type on dev_type.dev_num = ho_device.dev_type
select ho_device.*,license.*,ho_info.*,manufactuter.*,mf_device.*,dev_type.dev_name
from ((((ho_device
inner join license on ho_device.dev_code = license.dev_code)
inner join ho_info on ho_info.code = ho_device.code)
inner join manufactuter on manufactuter.code = ho_device.mf_code)
inner join mf_device on mf_device.dev_code = ho_device.mf_devcode)
inner join dev_type on dev_type.dev_num = ho_device.dev_type