22,210
社区成员
发帖
与我相关
我的任务
分享
select b.NDT图纸号,b.焊口号,UT.rpt_id as [ID_Report UT],UT.rpt_ReportNo as [UT NO] from vWeldBaseCh b
left outer join
( select rpt_SumType
,rpt_ID
,rpt_ReportNo
,item_ID_WeldBase
from vReportItems
where rpt_ID_Project in(5584) and rpt_SumType='UT'
group by rpt_SumType
,rpt_ReportNo
,rpt_id
,item_ID_WeldBase
) as UT
on UT.item_ID_WeldBase = b.id
where ID_Project in (5584)
order by b.NDT图纸号,b.焊口号