求一条联表查询SQL语句

[acrobatyuer]

表A是个索引表，表A中记录了一个用户ID，想通过这个用户ID加载到其它三张表中的内容，现在用INNER JOIN关键字进行查询的，问题就是当其它表其中有一项查询不到结果的时候，所有内容就全读取不到。想问一下有没有什么其它的办法可以实现查询啊！

SELECT     UserInfo.user_id, UserInfo.user_name, UserFortune.jinbi, TeamInfo.team_ab
FROM       (((UserInfo INNER JOIN FriendList ON UserInfoBase.user_id = ListFriends.friend_id)
				INNER JOIN UserGameFortune ON FriendList.friend_id = UserGameFortune.user_id)
				INNER JOIN UserTeam ON User_Team.user_id = FriendList.friend_id)
				INNER JOIN TeamInfo ON TeamInfo.team_id = UserTeam.team_id

WHERE	   FriendList.user_id = @UserID

[华仔lugl]

占个位置

[黄_瓜]

--try
SELECT     UserInfo.user_id, UserInfo.user_name, UserFortune.jinbi, TeamInfo.team_ab
FROM (SELECT a.user_id,b.friend_id,c.team_id FROM UserInfo a CROSS JOIN FriendList b
 CROSS JOIN TeamInfo c) x
LEFT JOIN UserInfo  ON user_id=x.user_id
LEFT JOIN UserGameFortune ON x.friend_id = UserGameFortune.user_id
LEFT JOIN UserTeam ON User_Team.user_id = FriendList.friend_id
LEFT JOIN TeamInfo ON TeamInfo.team_id = UserTeam.team_id AND team_id=x.team_id

[chenyuanloveccc]

这是么东东。。。。。。。。。

[xj116]

是是是是