那些让人揪心的mysql语句

 mysql/sql中的三条语句：

select co_balance,co_isstaff from dt_co where  co_id=156

select staff_group_id from dt_staff where co_id = 156

select count(*) a from dt_staff where staff_shouyetuijian = 1 and co_id = 156

整合成一条之后：

select co_balance,co_isstaff,staff_group_id,count from 
(select co_balance,co_isstaff from dt_co where co_id=156) a,
(select staff_group_id from dt_staff where co_id = 156) b,
(select count(*) as count from dt_staff where staff_shouyetuijian = 1 and co_id = 156) c