comparing on Joins, rather than just "where" clauses
in order to restrict the scope of rows to compare, it is often necessary to join the real table under examination with another, rather than just a standard "where" clause.
allow use of joins with conditions
2
votes
David M
shared this idea
You can perform complex WHERE clauses related to other tables by using other forms for example.
ID in (select OTHERID from OTHERTABLE)
Hopefully this workaround is satisfactory.