【mysql_初级】多表联查注意掉坑

1.原问题sql:

select DISTINCT t1.CATALOG_CODE,ORG_CODE,ORG_NAME,CATALOG_TITLE,t2.TABLE_NAME,t3.ID as ORG_ID from demo_wdis.catalog_schema t1 left join demo_wdis.dc_table_schema t2 
on t1.CATALOG_ID = t2.cataLog_id and locate('BAK',t2.TABLE_NAME ) = 0 and length(TABLE_NAME) >0 left join demo_uums.sys_organization t3 on t1.ORG_CODE = t3.CODE

坑一：需求是distinct只对catalog_code起效，实际是这里是对整行起效。解决方案 group by catalog_code

坑二：a left join b on  ,表a的过滤条件加在on后面不生效 ，需加在where后面。