firemail

标题: join on 与 where [打印本页]

作者: java 时间: 2018-4-28 19:40
标题: join on 与 where
查询条件连接后，一定要加上where条件才起作用

SELECT a.name, b.age FROM table_a a left join table_b b on a.name=b.name where (a.status > 0 or a.status is null)

欢迎光临 firemail (http://www.firemail.wang:8088/)