请问一个sql表连接的有关问题
请教一个sql表连接的问题？
表A和表B，之间的关系是A 一对多B ,根据id关联 表B里有多条A的记录， 表B里有个排序字段【qishu】来说明最近添加的A的记录，我现在只要查询表B里最近添加的一条和表A关联的所有数据
------解决方案--------------------
------解决方案--------------------
------解决方案--------------------
表A和表B，之间的关系是A 一对多B ,根据id关联 表B里有多条A的记录， 表B里有个排序字段【qishu】来说明最近添加的A的记录，我现在只要查询表B里最近添加的一条和表A关联的所有数据
------解决方案--------------------
select * from tblb t1 inner join tbla t2 on t1.a=t2.b
where t1.qishu= (select max(qishu) from tblb)
------解决方案--------------------
SELECT * FROM rv_licai a where shenhe=1 and yiduifu=0 and chanpin in('月息宝','新月息宝','月月万利宝')
AND a.id=(select top 1 licaiid from rv_duifu order by qishu desc )
order by bdated
------解决方案--------------------
SELECT a.*,b.qishu
FROM rv_licai a
INNER JOIN (select top 1 qishu,licaiid from rv_duifu order by qishu desc ) b ON b.licaiid=a.id
where shenhe=1 and yiduifu=0 and chanpin in('月息宝','新月息宝','月月万利宝')
order by bdated