select a.ProductID
,a.OrderDate
,a.ConDate
,a.ClientName
,a.MName
,a.TPMouldID
,b.Mould_Img
from OrderFormArc as a
left outer join MouldInfo as b on a.ProductID=b.ProductID
where a.Order_BS='0'
and convert(varchar(10),a.OrderDate,120) between '2005-09-01' and '2005-09-09'
and not exists(select 1
from MouldInfo
where ProductID=b.ProductID
and 不同值字段>b.不同值字段)
order by a.OrderDate desc,a.ClientName asc
,a.OrderDate
,a.ConDate
,a.ClientName
,a.MName
,a.TPMouldID
,b.Mould_Img
from OrderFormArc as a
left outer join MouldInfo as b on a.ProductID=b.ProductID
where a.Order_BS='0'
and convert(varchar(10),a.OrderDate,120) between '2005-09-01' and '2005-09-09'
and not exists(select 1
from MouldInfo
where ProductID=b.ProductID
and 不同值字段>b.不同值字段)
order by a.OrderDate desc,a.ClientName asc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货