这样行不行
select * from table1 u inner join
(select x.a, x.b, x.c
from table2 x inner join
(select a, max(b) as b from table2 group by a) y
on x.a = y.a and x.b = y.b) as v on u.a = v.a结果是:a b c a b c
1 2 3 1 2 3
2 4 3 2 1 3
select * from table1 u inner join
(select x.a, x.b, x.c
from table2 x inner join
(select a, max(b) as b from table2 group by a) y
on x.a = y.a and x.b = y.b) as v on u.a = v.a结果是:a b c a b c
1 2 3 1 2 3
2 4 3 2 1 3
结果本来就应该是:
a b c a b c
1 2 3 1 2 3
1 2 3 1 4 3
2 4 3 2 1 3