我有2个这样的表:
TableA
+----+------- --+
| id | name |
+----+----------+
| 1 | Max |
| 2 | Susan |
| 3 | Tom |
+----+----------+
TableB
+----+----------+----------+
| id | fromUser | toUser |
+----+----------+----------+
| 1 | 1 | 3 |
| 2 | 1 | 2 |
| 3 | 3 | 1 |
+----+----------+----------+
现在,我想让Tom成为结果,因为Max给Tom和Tom给了Max.
我知道Max的身份证.
我试过了:
select a.*, b.fromUser from TableA a
INNER JOIN TableB b
ON b.fromUser = a.id OR b.toUser = a.id
WHERE b.fromUser = 1 AND a.id =! 1
以及此查询的很多变体.但我得错了结果或者太多了!