mysql语句写法（左连与子查询结合）实战

select 

count(vipid) as people,

card_number 

from vip 

group by card_number

) as v

on 

c.card_number=v.card_number 

left join 

`vip_type` as t 

on

c.type_id=t.type_id 

where 

c.store_key=‘556655‘;

mysql语句写法（左连与子查询结合）实战

标签：msyql