SQL Server数据库
如何把这些记录放在一行显示
select distinct top 30 mes_wop.AutoID,mes_wo.WlcspLot,a_ap.AreaProcessName,mes_wop.InDieQty,mes_wop.OutDieQty,
convert(varchar,mes_wop.InTime,120)as InTime,convert(varchar,mes_wop.OutTime,120)as OutTime
,cwo.WaferLot,mes_wi.waferno
from MES_WorkOrder mes_wo
left join MES_WorkorderProcess mes_wop on mes_wo.AutoID = mes_wop.WorkorderID and mes_wop.Deleted = 0
left join A_AreaProcess a_ap on a_ap.PrimaryKey = mes_wop.ProcessItemID and a_ap.Deleted = 0
left join MES_Workorder_WaferInfo mes_wo_wi on mes_wo_wi.WorkorderID= mes_wo.AutoID
left join MES_WaferInfo mes_wi on mes_wi.AutoID= mes_wo_wi.WaferInfoID
left join Customer_WO cwo on cwo.AutoID=mes_wi.CustomerWOID
where mes_wo.Deleted = 0 and mes_wop.InDieQty is not null order by mes_wop.AutoID;