delete from Sheet1 where sheet1.to_mobile in (select to_mobile from Sheet2)
deleteSheet1 where sheet1.to_mobile in (select to_mobile from Sheet2)
这两句效果一样哦
没有任何区别,加上FROM更规一些。delete from Sheet1 where sheet1.to_mobile in (select to_mobile from Sheet2)与delete Sheet1 where sheet1.to_mobile in (select to_mobile from Sheet2)以及delete from Sheet1和delete Sheet1都是相同的。可以在企业管理器中运行一下,如果不加入FROM,系统会自动加上的。扩展资料:数据修改...
没有任何区别,可能加上FROM更规一些吧。delete from Sheet1 where sheet1.to_mobile in (select to_mobile from Sheet2) 与delete Sheet1 where sheet1.to_mobile in (select to_mobile from Sheet2) 以...