摘要: table a(id, type):id type----------------------------------1 12 13 2table b(id, class):id class---------------------------------1 12 2sql语句1:select a.*, b.* from a left join b on a.id = b.id and a.type = 1;sql语句2:select a.*, b.* from a left join b on a.id = b.id where a.type = 1;sql语句3:select a.*, b 阅读全文
posted @ 2014-01-02 18:05 Anlycp 阅读(322) 评论(1) 推荐(0) 编辑