如何刪除與SQLServer的內(nèi)部連接？我想刪除使用INNER JOIN在……里面SQLServer 2008.但我知道這個錯誤：MSG 156，15級，狀態(tài)1，15號線不正確的語法靠近關(guān)鍵字‘內(nèi)部’。我的代碼：DELETE FROM WorkRecord2
INNER JOIN Employee ON EmployeeRun=EmployeeNoWHERE Company = '1' AND Date = '2013-05-06'
3 回答
SMILET
TA貢獻1796條經(jīng)驗 獲得超4個贊
DELETE wFROM WorkRecord2 wINNER JOIN Employee e ON EmployeeRun=EmployeeNoWHERE Company = '1' AND Date = '2013-05-06'
慕桂英546537
TA貢獻1848條經(jīng)驗 獲得超10個贊
DELETEFROMORDER BY
DELETE WorkRecord2 FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' AND Date = '2013-05-06';
心有法竹
TA貢獻1866條經(jīng)驗 獲得超5個贊
DELETE FROM dbo.WorkRecord2 WHERE EmployeeRun IN ( SELECT e.EmployeeNo FROM dbo.Employee e WHERE ...)
DELETE FROM dbo.WorkRecord2 WHERE EXISTS( SELECT 1 FROM dbo.Employee e WHERE EmployeeRun = e.EmployeeNo AND ....)
添加回答
舉報
0/150
提交
取消