java 发表于 2018-4-28 19:40:53

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)
页: [1]
查看完整版本: join on 与 where