A左关联B,取从B表多条记录取一条
摘要:
select * from aleft join b on a.ID = b.IDwhere not exists (select 1 from b t where t.ID = b.ID and t.TimeEnd > b.TimeEnd) 阅读全文
posted @ 2011-12-13 10:05 滴d 阅读(713) 评论(0) 推荐(0) 编辑
posted @ 2011-12-13 10:05 滴d 阅读(713) 评论(0) 推荐(0) 编辑