sql中表连接中的列 一对多(有相同主键)怎么连接

2025-03-28 06:53:09
推荐回答(1个)
回答1:

select x.a,min(y.b) b from x inner join y on x.a=y.a group by x.a
select y.a,min(y.b) b from y group by y.a