select id=identity(int,1,1),* into #t from 表2select a.编号,b.编号,(case when id=(select min(id) from #t where 编号=b.编号)
then a.数量
else 0
end )
from 表1 a inner join #t b on a.编号=b.编号
then a.数量
else 0
end )
from 表1 a inner join #t b on a.编号=b.编号
SELECT B.编号,A.编号,CASE WHEN X.PK IS NULL THEN 0 ELSE A.数量 END AS 数量
FROM 从表 B INNER JOIN 主表 A ON A.编号=B.编号
LEFT JOIN (select 编号,MIN(PK) AS PK from 从表 group by 编号) X ON B.编号=X.编号
___________________________________to lightJing()
你写的SQL在我这边没效果呀