45 lines
1.1 KiB
Transact-SQL
45 lines
1.1 KiB
Transact-SQL
|
ALTER VIEW [dbo].[View_InformationProject_ConstructionStandardSelectedItem]
|
||
|
|
/*±ê×¼¹æ·¶±æʶѡÔñÏîÁбíÊÓͼ*/
|
||
|
|
AS
|
||
|
|
SELECT Item.ConstructionStandardSelectedItemId,
|
||
|
|
Item.ConstructionStandardIdentifyId,
|
||
|
|
Item.StandardId,
|
||
|
|
Identify.ProjectId,
|
||
|
|
List.StandardGrade,
|
||
|
|
List.StandardNo,
|
||
|
|
List.StandardName,
|
||
|
|
List.AttachUrl,
|
||
|
|
List.IsSelected1,
|
||
|
|
List.IsSelected2,
|
||
|
|
List.IsSelected3,
|
||
|
|
List.IsSelected4,
|
||
|
|
List.IsSelected5,
|
||
|
|
List.IsSelected6,
|
||
|
|
List.IsSelected7,
|
||
|
|
List.IsSelected8,
|
||
|
|
List.IsSelected9,
|
||
|
|
List.IsSelected10,
|
||
|
|
List.IsSelected11,
|
||
|
|
List.IsSelected12,
|
||
|
|
List.IsSelected13,
|
||
|
|
List.IsSelected14,
|
||
|
|
List.IsSelected15,
|
||
|
|
List.IsSelected16,
|
||
|
|
List.IsSelected17,
|
||
|
|
List.IsSelected18,
|
||
|
|
List.IsSelected19,
|
||
|
|
List.IsSelected20,
|
||
|
|
List.IsSelected21,
|
||
|
|
List.IsSelected22,
|
||
|
|
List.IsSelected23,
|
||
|
|
List.IsSelected90
|
||
|
|
FROM dbo.Law_HSSEStandardsList AS List
|
||
|
|
LEFT JOIN dbo.InformationProject_ConstructionStandardSelectedItem AS Item ON List.StandardId =Item.StandardId
|
||
|
|
LEFT JOIN dbo.InformationProject_ConstructionStandardIdentify AS Identify ON Item.ConstructionStandardIdentifyId =Identify.ConstructionStandardIdentifyId
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
GO
|
||
|
|
|
||
|
|
|