LEFT JOIN 

SELECT `l`.`card_name`, `l`.`card_sn`, `l`.`card_start`, `l`.`active_time`, `i`.`name`, `m`.`mobile` 
FROM `crm_member_card_list` `l` 
LEFT JOIN `member` `m` ON l.member_id = m.member_id 
LEFT JOIN `member_info` `i` ON m.member_id = i.member_id 
WHERE l.order_id = 22 and l.cp_member_id = 88595

-- member && member_info  绑定关联 和 crm_member_card_list 联合查询

 

posted @ 2015-11-26 17:29  WilliamHu  阅读(99)  评论(0)  编辑  收藏  举报