在我两次与同一个表连接之后，如何在 WHERE 子句中调用具有相同列名的值

Question

我将从一个例子开始：

*Table1*
ID
PhoneNumber1
PhoneNumber2
*Table2*
PhoneNumber
SomeOtherField
SELECT *
FROM Table1 t1
INNER JOIN Table2 t2
   ON t2.PhoneNumber = t1.PhoneNumber1
INNER JOIN Table2 t3
   ON t3.PhoneNumber = t1.PhoneNumber2
-- here is the question how do I call same column which have same name?
-- I want to do a where clause like below:
WHERE SomeOtherField(from first Table2) = SomeOtherField(from second Table2)

这个例子来自下面的问题，但我们问的是不同的事情：两次加入同一张桌子的最佳方式是什么？

Answer 1

WHERE t2.SomeOtherField = t1.SomeOtherField