追答select A.*,B.price from A left join (select top 1 gid,price from B order by date desc) B on A.gid=B.gid追问
价格只查询出了第一个
追答select A.*,B.price from A left join (select * from B b1 where [date]=(select max([date]) from B where B.gid=b1.gid)) B on A.gid=B.gid select * from B