在我的数据库中有4个关系表,并希望加入它们以获得总价值…例如,我有朋友,家人,跟随和熟人,并希望加入这些以获得“全部”值.
表格格式如下:
友
id follower following
---------------------
1 2 3
2 4 5
家庭
id follower following
---------------------
1 5 6
2 7 8
以下
id follower following
---------------------
1 9 10
2 11 12
熟人
id follower following
---------------------
1 13 14
2 15 16
加入所有4个表是正确的查询…
SELECT following
FROM friends
INNER JOIN family ON friends.following=family.following
INNER JOIN following ON friends.following=following.following
INNER JOIN acquaintances ON friends.following=acquaintances.following
WHERE follower='id'
基本上我想加入并检索id = my id的所有四个表中的“follow”值