mysql join带条件查询

SELECT count(if(o.order_status=1,1,null)) as "symbol_1",count(if(o.order_status=2,1,null)) as "symbol_2",count(if(o.order_status=3,1,null)) as "symbol_3",count(if(o.order_status=4,1,null)) as "symbol_4",count(if(o.order_status=5,1,null)) as "symbol_5",count(if(o.order_status=6,1,null)) as "symbol_6",count(if(o.order_status=7,1,null)) as "symbol_7" FROM ful_ky_order oLEFT JOINful_ky_contract cONc.id=o.contract_idLEFT JOINful_custom cuONc.custom_id=cu.idleft join ful_admin_userauONau.id=cu.user_id where au.name like "%张俊君%";

等同于

SELECT count(if(o.order_status=1,1,null)) as "symbol_1",count(if(o.order_status=2,1,null)) as "symbol_2",count(if(o.order_status=3,1,null)) as "symbol_3",count(if(o.order_status=4,1,null)) as "symbol_4",count(if(o.order_status=5,1,null)) as "symbol_5",count(if(o.order_status=6,1,null)) as "symbol_6",count(if(o.order_status=7,1,null)) as "symbol_7" FROM ful_ky_order oLEFT JOINful_ky_contract cONc.id=o.contract_idLEFT JOINful_custom cuONc.custom_id=cu.idjoin (select * from ful_admin_user where name like "%张俊君%")auONau.id=cu.user_id;

mysql join带条件查询

原文：https://www.cnblogs.com/promise1117/p/15065064.html