MySQL的加入查询{如何得到以下结果}
问题描述：
+----------+
|id | data |
+----------+
|1 | USRA |
+----------+
|4 | USRB |
+----------+
表2
+----------+
|cid | mid |
+----------+
|1 | 4 |
+----------+
|4 | 1 |
+----------+
结果表
+----------------------+
|table1_id | table2_id |
+----------------------+
|USRA | USRB |
+----------------------+
|USRB | USRA |
+----------------------+
答
SELECT
a.data,
b.data
FROM
Table1 a
INNER JOIN
Table2 t2
ON a.id = t2.cid
INNER JOIN
Table1 b
ON b.id = t2.mid
答
尝试：
SELECT t1.data, t3.data
FROM tab1 t1, tab2 t2, tab1 t3
WHERE t1.id = t2.id
AND t3.id = t2.mid
答
SELECT t3.data, t1.data
FROM a t1, b t2, a t3
WHERE t1.id = t2.cid
AND t3.id = t2.mid
您需要选择'FROM'表2和'INNER JOIN' table1的两倍 – zerkms 2014-11-06 08:19:05
执行表以某种方式相互关联 – Strawberry 2014-11-06 08:19:36
，你可以帮我查询 – 2014-11-06 08:20:46