SELECT J2.fjobno AS JobOrderNo, J2.fsono + LTRIM(RTRIM(J2.fkey)) AS SOKey, I.fcpro_name AS WorkCenterName
FROM dbo.jodrtg AS J1 INNER JOIN
dbo.inwork AS I ON J1.fpro_id = I.fcpro_id INNER JOIN
dbo.jomast AS J2 ON J1.fjobno = J2.fjobno
WHERE (I.fcpro_name LIKE '%-G%')
GROUP BY J2.fjobno
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY