select fxno from ufx
left join ufxgkcs on ufxgkcs.fxno = ufx.fxno
and
ufxgkcs.gkcsno = (select max (gkcsno) FROM ufxgkcs b WHERE ufx.fxno = b.fxno )
sql 语句主表一条数据对应子表多条数据取最新的一条
最新推荐文章于 2024-05-14 17:15:27 发布
select fxno from ufx
left join ufxgkcs on ufxgkcs.fxno = ufx.fxno
and
ufxgkcs.gkcsno = (select max (gkcsno) FROM ufxgkcs b WHERE ufx.fxno = b.fxno )