注用 join后, 条件要写在之后select * from bdCustomerAllocate aleft join bdFollowRecord bon ( a.id = b.allocateid and b.id = (select top 1 id from bdFollowRecord where allocateid = a.id order by followdate desc ))where a.SalesStaf