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 as a,co_isstaff as b,1 as type from dt_co where co_id=156
union all
select staff_group_id as a, '' as b, 2 as type from dt_staff where co_id = 156
union all
select count(*) as a, '' as b, 3 as type from dt_staff where staff_shouyetuijian = 1 and co_id = 156
根据type判断a,b分别sql的查询结果
------解决方案--------------------
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