多表查询

[sql]代码库

select us.username,u.cared,s.name,c.levelid,u.jointime,m.name from usr2card u 
left join ext_cardlevel c on c.cardid = u.cared
left join users us on u.userid = us.id
left join shop s on c.shopid = s.id
left join merchant m on s.mid = m.id 
where 1=1