mysql 2つの結果セットをマージ

370 ワード



select status, count(status),langtype
from card.card_verify
group by status, langtype
having status in(30,31,1)
union
select status, count(status),3 as langtype
from card.card_verify 
where status = 30
and langtype = 0 and part!=1 and pre_verify_user<0 and verify_type>0