表1:
表2:
现在要获得repid=48 对应表2的最后一天记录,也就是要查处dealid=58
SQL:
select *
from mgruserrepresentationsdeal md
where md.dealid = (select max(dealid) dealid
from mgruserrepresentationsdeal tp
where tp.repid ='48')
结果:
现在要获得表1里每个repid对应表2的记录并取最后条数据
SQL:
select *
from MGRUSERREPRESENTATIONS mr,(select *
from mgruserrepresentationsdeal md
where md.dealid = (select max(dealid) dealid
from mgruserrepresentationsdeal tp
where tp.repid = md.repid)) m
where mr.repid = m.repid
结果: