SQL 2个查询结果 如何匹配

Question

SELECT CONCAT(品号,钢卷号) AS PHGGH ,数量 FROM (SELECT PH as '品号',GGH as '钢卷号',SUM(SL) as '数量' FROM dbo.zsgl
WHERE YXM = 'Y' GROUP BY PH,GGH) AS A WHERE 数量 > 0

SELECT CONCAT(PH,GGH) AS PHGGH,substring(SJBM,1,8) AS 入库日期 from dbo.zsgl where JJ='r' and YXM = 'Y' ORDER BY SJBM ASC

我需要达到的结果 是通知第一条查询语句，再去匹配第二条查询语句里相对应的数据 。

Answer 1

select a.*,b.入库日期 from
(SELECT CONCAT(品号,钢卷号) AS PHGGH ,数量 FROM (SELECT PH as '品号',GGH as '钢卷号',SUM(SL) as '数量' FROM dbo.zsgl
WHERE YXM = 'Y' GROUP BY PH,GGH) AS A WHERE 数量 > 0
）a
left join
(
SELECT CONCAT(PH,GGH) AS PHGGH,substring(SJBM,1,8) AS 入库日期 from dbo.zsgl where JJ='r' and YXM = 'Y' ORDER BY SJBM ASC
) b
on a.PHGGH = b. PHGGH

试试 估计效率不是很好，