Question

如何取得left join的第二表中符合条件的第一条记录

Answer 1

select a.*,
ifnull(b.time,'') as time,
ifnull(b.txt,'') as txt
from tableA as a
left join tableB as b
on a.tid = b.tid
group by a.tid
order by a.tid