select a.* from 表1 a,表2 b where a.makey=b.makey order by b.receivetime
select m.maKey,m.checkDate,m.conten from master m inner join detail d on m.maKey=d.maKey group by m.maKey,m.checkDate,m.conten order by max(d.receiveTime) desc
select makey,checkDate,content from master where makey in (select makey from detail order by ReceiveTime desc)
SELECT B.maKey,B.CheckDate,B.Content FROM (select maKey from detail group by maKey order by max(d.receiveTime) desc) A INNER JOIN master B ON A.maKey=B.maKey
where a.makey=b.makey
order by b.receivetime
from master m inner join detail d on m.maKey=d.maKey
group by m.maKey,m.checkDate,m.conten
order by max(d.receiveTime) desc
where makey in (select makey from detail order by ReceiveTime desc)
FROM
(select maKey
from detail
group by maKey
order by max(d.receiveTime) desc) A
INNER JOIN master B ON A.maKey=B.maKey