sql="insert into biyesheng select jiben.xuehao,xingming,biye.biye,jiating.dizhi,lianxi.lianxifangshi from jiben,biye,jiating,lianxi where jiben.banhao*='"&banji&"' and jiben.xuehao*=biye.xuehao and jiben.xuehao*=jiating.xuehao and jiben.xuehao*=lianxi.xuehao"Orsql="insert into biyesheng select jiben.xuehao,xingming,biye.biye,jiating.dizhi,lianxi.lianxifangshi from jiben Left Join biye On jiben.xuehao*=biye.xuehao
Left Join jiating On jiben.xuehao*=jiating.xuehao
Left Join lianxi On jiben.xuehao*=lianxi.xuehao"
Where jiben.banhao*='"&banji&"'"
Left Join jiating On jiben.xuehao*=jiating.xuehao
Left Join lianxi On jiben.xuehao*=lianxi.xuehao"
Where jiben.banhao*='"&banji&"'"
现在执行不了。
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
/asp/xsgl/quest19.asp, 第 13 行为什么??
还是不行。。
ACCESS数据库。
其他表的记录都是一对一的,这样我就可以把他们合起来记录。呵呵。继续征集答案中……
只能用LEFT JOIN