一条SQL命令，执行后，错误提示为：表达式太复杂
DELETE FROM goods_lyf WHERE (goods_lyf.goodsid NOT in (select goodsid FROM goods_lt)) AND ;
(goods_lyf.goodsid NOT in (select WuLiaoID FROM DingZhuanZiYunShu_P))
删除goods_lyf ，条件是：goods_lyf.goodsid不在goods_lt.goodsid里面;并且,同时goods_lyf.goodsid也不在DingZhuanZiYunShu_P.WuLiaoID
我自己想想,这个表达式不复杂啊.
望老师帮改正一下此命令.
------解决方案--------------------------------------------------------
try:
* vfp9.0
Delete From goods_lyf Where goods_lyf.goodsid Not In (Select A.goodsid From ;
(Select goodsid From goods_lt Union All Select WuLiaoID AS goodsid From DingZhuanZiYunShu_P) A)