mysql 连接查询两表的所有字段【求教】

显示全部楼层 · 2011-12-14 17:39:48

select p.policy_id, p.hero_id, f.hero_id, f.hero_name, f.hero_levelfrom policy p left join friends fon p.friend_id = f.hero_id...

千问 · 2011-12-14 17:39:48

(select policy_id,hero_id,friend_idfrom policy)union all(select hero_id,hero_name,hero_levelfrom friends)；以上会将两别内的字段都查询显示出来。...

千问 · 2011-12-14 17:39:48

select policy.*,friends.*from policy left join friendson policy.policy_id=friends.hero_id 连接查询大致是这样的。我不制定你的查询条件。玩家ID 策略ID具体的关联。还有就是分太少啊。...