SELECT [vGroupUser].[gcode] AS [gcode], [vGroupUser].[dept] AS [dept], [vGroupUser].[level] AS [level], [vGroupUser].[name] AS [name], [vGroupUser].[nameE] AS [nameE], [vGroupUser].[grade] AS [grade], [vGroupUser].[email] AS [email], [vGroupUser].[tel] AS [tel], [vGroupUser].[indate] AS [indate], [vGroupUser].[outdate] AS [outdate], [vGroupUser].[hp] AS [hp], [vGroupUser].[place] AS [place], [vGroupUser].[ads_employNo] AS [ads_employNo], [vGroupUser].[ads_title] AS [ads_title], [vGroupUser].[ads_created] AS [ads_created], [vGroupUser].[memo] AS [memo], [vGroupUser].[processs] AS [processs], [vGroupUser].[id] AS [id], [vGroupUser].[state] AS [state], [vGroupUser].[useJobReport] AS [useJobReport], [vGroupUser].[useUserState] AS [useUserState], [vGroupUser].[password] AS [password] FROM [dbo].[vGroupUser] AS [vGroupUser] SELECT [vJobReportForUser].[idx] AS [idx], [vJobReportForUser].[pdate] AS [pdate], [vJobReportForUser].[gcode] AS [gcode], [vJobReportForUser].[id] AS [id], [vJobReportForUser].[name] AS [name], [vJobReportForUser].[process] AS [process], [vJobReportForUser].[type] AS [type], [vJobReportForUser].[svalue] AS [svalue], [vJobReportForUser].[hrs] AS [hrs], [vJobReportForUser].[ot] AS [ot], [vJobReportForUser].[requestpart] AS [requestpart], [vJobReportForUser].[package] AS [package], [vJobReportForUser].[userProcess] AS [userProcess], [vJobReportForUser].[status] AS [status], [vJobReportForUser].[projectName] AS [projectName], [vJobReportForUser].[description] AS [description], [vJobReportForUser].[ww] AS [ww], [vJobReportForUser].[otStart] AS [otStart], [vJobReportForUser].[otEnd] AS [otEnd], [vJobReportForUser].[ot2] AS [ot2], [vJobReportForUser].[otReason] AS [otReason], [vJobReportForUser].[grade] AS [grade], [vJobReportForUser].[indate] AS [indate], [vJobReportForUser].[outdate] AS [outdate] FROM [dbo].[vJobReportForUser] AS [vJobReportForUser]