MySql教程

mysql join带条件查询

本文主要是介绍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带条件查询的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!