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.焊口号