CREATE VIEW View_TestPackage_PipelineList
as
/*********ÊÔѹ°üÃ÷ϸ**********/
select l.PT_PipeId,
l.PTP_ID,
l.PipelineId,
l.TestPressure,
t.ProjectId,
t.TestPackageNo,
t.TestPackageName,
t.Remark,
t.UnitWorkId,
t.Tabler,
t.TableDate,
p.PipelineCode,
uw.UnitWorkCode,
uw.UnitWorkName,
uw.UnitId,
u.UnitCode,
u.UnitName
from PTP_PipelineList l
left join PTP_TestPackage as t on t.PTP_ID=l.PTP_ID
left join HJGL_Pipeline p on p.PipelineId = l.PipelineId
left join WBS_UnitWork uw on uw.UnitWorkId = t.UnitWorkId
left join Base_Unit u on u.UnitId =uw.UnitId
go