delete tb_orderdish where ch_billno in (select ch_billno from tb_orderdish_tmp) --提示tb_orderdish
delete tb_djnolist where ch_billno in (select ch_billno from tb_master_tmp) --提示tb_djnolistdelete tb_table where ch_billno in (select ch_billno from tb_table_tmp) --提示tb_table