根据表二的值,表二数据会变动会增加, 来选出表一的列名的值,合并成一列

根据表二的值,表二数据会变动会增加,
来选出表一的列名的值,合并成一列

要写活的,写死的就没有意义了

SELECT a.PartnerItemCode,b.Spl1,a.Quantity,b.Spl2,a.ModleCode,b.Spl3
FROM t1 a
JOIN t2 b ON a.CardCode=b.CardCode
where a.CardCode='C000001'

UNION ALL

SELECT a.PartnerItemCode,b.Spl1,a.ModleCode,b.Spl2,a.Quantity,b.Spl3
FROM t1 a
JOIN t2 b ON a.CardCode=b.CardCode
where a.CardCode='C000002'