抄来的代码

delete a from wh_Prodbarcode a inner join  wh_prodoutputdetail b
on a.poutputdetailid=b.poutputdetailid where a.isout=1 and  a.poutputdetailid!=0 and b.opdate<'2010-1-1'