delete from tempdb..dispatchlist01,UFDATA_006_2004..dispatchlist where
tempdb..dispatchlist01.dlid=UFDATA_006_2004..dispatchlist.dlid and tempdb..dispatchlist01.cdlcode=UFDATA_006_2004..dispatchlist.cdlcode
这样的话,删 tempdb..dispatchlist01表的!
tempdb..dispatchlist01.dlid=UFDATA_006_2004..dispatchlist.dlid and tempdb..dispatchlist01.cdlcode=UFDATA_006_2004..dispatchlist.cdlcode
这样的话,删 tempdb..dispatchlist01表的!
------------------------
delete from tempdb..dispatchlist01,UFDATA_006_2004..dispatchlist where
tempdb..dispatchlist01.dlid=UFDATA_006_2004..dispatchlist.dlid and tempdb..dispatchlist01.cdlcode=UFDATA_006_2004..dispatchlist.cdlcode
这样的话,删 tempdb..dispatchlist01表的!---------------------------
这样还是错的
delete from tempdb..dispatchlist01 from UFDATA_006_2004..dispatchlist where
tempdb..dispatchlist01.dlid=UFDATA_006_2004..dispatchlist.dlid and tempdb..dispatchlist01.cdlcode=UFDATA_006_2004..dispatchlist.cdlcode应该删 tempdb..dispatchlist01表的!