获取去掉交集部分的数据

 select * from @tbMN a where not exists (
  select * from ModelLossInfo where ModelName=a.ModelName
  and PN=a.PartNumber and LineName=@LineName
  and CONVERT(varchar(12),ScanDate,23)=convert(varchar(12),@ScanDate,23)

posted @ 2012-08-29 13:48  洗耳恭听兼烂笔头  阅读(217)  评论(0)    收藏  举报