DELETE FROM TempUniBOM as T
Where Exists(Select * from TempUniBOMUse Where BargainNO=T.BargainNO AND CIQPN=T.CIQPN)出錯!提示如下:
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'as'.
Where Exists(Select * from TempUniBOMUse Where BargainNO=T.BargainNO AND CIQPN=T.CIQPN)出錯!提示如下:
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'as'.
DELETE TempUniBOM
FROM TempUniBOM as T
Where Exists(Select * from TempUniBOMUse Where BargainNO=T.BargainNO AND CIQPN=T.CIQPN)
Where Exists(Select * from TempUniBOMUse T Where BargainNO=T.BargainNO AND CIQPN=T.CIQPN)
FROM TempUniBOM as T
Where Exists(Select * from TempUniBOMUse Where BargainNO=T.BargainNO AND CIQPN=T.CIQPN)