12 2011 档案

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 阅读(730) 评论(0) 推荐(0)

导航