4表查询有关问题_Sql Server

4表查询问题
select [user].userName,shop.shopname,role.rolename from [user],shop,userrole,role where [user].userid='qq'
and [user].shopid = shop.shopid and userrole.roleid=role.roleid and [user].userid=userrole.userid
上面的语句是4表查询,目的是将userName,shopName,rolename选择出来,还有其他办法吗?听过有个上面join
比如
select [user].userName,shop.shopnamefrom [user]
join shop on [user].userid='qq' and [user].shopid = shop.shopid
可是我不懂怎么连接3个以上的表

------解决方案--------------------
你的方法要快过左连接left join
四表连接方法如下:

SQL code

select a.*,b.*,c.*,d.* from a left join b on a.id = b.idleft join c on a.id = c.idleft join d on a.id = d.idand a.userid='qq'
------解决方案--------------------
SQL codeselect [user].userName, shop.shopname, role.rolename from [user]join shop on [user].shopid=shop.shopidjoin userrole on [user].userid=userrole.useridjoin role on userrole.roleid=role.roleid--join another tablewhere [user].userid='qq'