select a.KaHao,b.mingma from Tbl_checkIn a,tbl_ShouPiao b where a.KaHao=b.kahao and mingma>='0014' and mingma<='0016'本人小菜,初学SQL,这是多表查询写的语句,然后查出来结果想要删除掉,把select换成delete不能执行,请教各位该如何写呢?
调试欢乐多
delete Tbl_checkIn from Tbl_checkIn a,tbl_ShouPiao b where a.KaHao=b.kahao and mingma>='0014' and mingma<='0016'
那再写一个 delete !嘿嘿..同时删两个表中数据,我还不太会..