join on 与 where

java

查询条件连接后，一定要加上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)