SELECT
[T_Sys_RoleLinkPower].[RoleID] AS [RoleID],
[T_Sys_RoleLinkPower].[PowerID] AS [PowerID],
[T_Sys_RoleLinkPower].[OpTime] AS [OpTime],
[T_Sys_RoleLinkPower].[OpName] AS [OpName]
FROM [dbo].[T_Sys_RoleLinkPower] AS [T_Sys_RoleLinkPower]
SELECT
[tb_Report_FiveScreenStandard].[ID] AS [ID],
[tb_Report_FiveScreenStandard].[Name] AS [Name],
[tb_Report_FiveScreenStandard].[LastYear] AS [LastYear],
[tb_Report_FiveScreenStandard].[Jan] AS [Jan],
[tb_Report_FiveScreenStandard].[Feb] AS [Feb],
[tb_Report_FiveScreenStandard].[Mar] AS [Mar],
[tb_Report_FiveScreenStandard].[Apr] AS [Apr],
[tb_Report_FiveScreenStandard].[May] AS [May],
[tb_Report_FiveScreenStandard].[Jun] AS [Jun],
[tb_Report_FiveScreenStandard].[Jul] AS [Jul],
[tb_Report_FiveScreenStandard].[Aug] AS [Aug],
[tb_Report_FiveScreenStandard].[Sept] AS [Sept],
[tb_Report_FiveScreenStandard].[Oct] AS [Oct],
[tb_Report_FiveScreenStandard].[Nov] AS [Nov],
[tb_Report_FiveScreenStandard].[Dec] AS [Dec],
[tb_Report_FiveScreenStandard].[CreateTime] AS [CreateTime]
FROM [dbo].[tb_Report_FiveScreenStandard] AS [tb_Report_FiveScreenStandard]
SELECT
[tb_ReportPaintingScreen].[color] AS [color],
[tb_ReportPaintingScreen].[productInfo] AS [productInfo],
[tb_ReportPaintingScreen].[sumNum] AS [sumNum],
[tb_ReportPaintingScreen].[oncePassNum] AS [oncePassNum],
[tb_ReportPaintingScreen].[oncePassRate] AS [oncePassRate],
[tb_ReportPaintingScreen].[sumPassNum] AS [sumPassNum],
[tb_ReportPaintingScreen].[sumPassRate] AS [sumPassRate]
FROM [dbo].[tb_ReportPaintingScreen] AS [tb_ReportPaintingScreen]
SELECT
[tb_ReportPaintingScreen_pg].[color] AS [color],
[tb_ReportPaintingScreen_pg].[productInfo] AS [productInfo],
[tb_ReportPaintingScreen_pg].[sumNum] AS [sumNum],
[tb_ReportPaintingScreen_pg].[hgNum] AS [hgNum],
[tb_ReportPaintingScreen_pg].[DefectName1] AS [DefectName1],
[tb_ReportPaintingScreen_pg].[defectRate1] AS [defectRate1],
[tb_ReportPaintingScreen_pg].[DefectName2] AS [DefectName2],
[tb_ReportPaintingScreen_pg].[defectRate2] AS [defectRate2],
[tb_ReportPaintingScreen_pg].[DefectName3] AS [DefectName3],
[tb_ReportPaintingScreen_pg].[defectRate3] AS [defectRate3],
[tb_ReportPaintingScreen_pg].[DefectName4] AS [DefectName4],
[tb_ReportPaintingScreen_pg].[defectRate4] AS [defectRate4],
[tb_ReportPaintingScreen_pg].[DefectName5] AS [DefectName5],
[tb_ReportPaintingScreen_pg].[defectRate5] AS [defectRate5]
FROM [dbo].[tb_ReportPaintingScreen_pg] AS [tb_ReportPaintingScreen_pg]
SELECT
[test1].[ID] AS [ID],
[test1].[StationID] AS [StationID],
[test1].[StockNo] AS [StockNo],
[test1].[PrintType] AS [PrintType],
[test1].[OneBarCode] AS [OneBarCode],
[test1].[PlanID] AS [PlanID],
[test1].[CreateTime] AS [CreateTime],
[test1].[ProductName] AS [ProductName],
[test1].[PartNo] AS [PartNo],
[test1].[ProductDate] AS [ProductDate],
[test1].[ClassName] AS [ClassName]
FROM [dbo].[test1] AS [test1]