我有两个表,t1,t2结构如下:
t1
id day code1 code2
1 2008-12-24 a0001 b0001
2 2008-12-26 a0001 b0001
t2
id code1 code2 a b
1 a0001 b0001 a1 b1我想得到的结果是:day code1 code2 a b
2008-12-26 a0001 b0001 a1 b1
对mysql不熟。望高手指点。
t1
id day code1 code2
1 2008-12-24 a0001 b0001
2 2008-12-26 a0001 b0001
t2
id code1 code2 a b
1 a0001 b0001 a1 b1我想得到的结果是:day code1 code2 a b
2008-12-26 a0001 b0001 a1 b1
对mysql不熟。望高手指点。
'a0001' as code1,
'b0001' as code2,
'a1' as a,
'b1 as b ;
select code1,code2,max(day) from t1 group by code1,code2 ) a
left join t2 b on a.code1=b.code1 and a.code2=b.code2
select code1,code2,max(day) from t1 group by code1,code2 ) a
left join t2 b on a.code1=b.code1 and a.code2=b.code2