delete from b where xh in (select xh form B in 'H:\Documents and Settings\Administrator\桌面\客户端.mdb')
比如这一句,现在我的主键不是xh了,是未知的,而且是个联合主键,大家帮我写个获得主键字段的句子代替红色的部分,搞了半天,找不到资料,即使找到了也看不大懂。
delete from b where xh in (select xh form B in 'H:\Documents and Settings\Administrator\桌面\客户端.mdb')
比如这一句,现在我的主键不是xh了,是未知的,而且是个联合主键,大家帮我写个获得主键字段的句子代替红色的部分,搞了半天,找不到资料,即使找到了也看不大懂。
delete from b where xh in (select xh form B in 'H:\Documents and Settings\Administrator\桌面\客户端.mdb')
-----------------------------
完全不合乎语法到底想干嘛?
--另一种
delete from b where CHECKSUM(xh,XH2) in (select CHECKSUM(xh,XH2) form B in 'H:\Documents and Settings\Administrator\桌面\客户端.mdb')
可以用这种吗?