7,713
社区成员
发帖
与我相关
我的任务
分享
select
list.[BoxNum],
list.[Cont_ID],
list.[MateNum],
list.[MateCount],
list.[MateCount1],
box.[Country],
box.[Dept]
box.[Assortment],
box.[DeliverDate],
ClientData.[Color],
ClientData.[Size]
from ((T_ClientBoxListData list
left join (select distinct(BoxNum) as boxNum1,Country,Dept,Assortment,DeliverDate from T_ClientBoxData)
box on list.BoxNum = box.BoxNum1)
left join (select distinct(jan) as jan1,size,color from T_ClientData)
ClientData on list.MateNum = ClientData.Jan1)