mysql語句寫法（左連與子查詢結合）實戰

select 

c.card_number,

c.card_name,

t.type_name,

c.card_discount,

t.type_low,

c.card_integral,

(c.card_recharge_balance+c.card_give_balance) as num,

v.people,

c.card_time 

from 

`vip_card` as c 

left join 

(

count(vipid) as people,

card_number 

from vip 

group by card_number

) as v

on 

c.card_number=v.card_number 

`vip_type` as t 

on

c.type_id=t.type_id 

where 

c.store_key='556655';

本文轉自 Lee_吉  部落格，原文連結：   http://blog.51cto.com/12173069/1968333     如需轉載請自行聯系原作者