BigQuery Issue - LEFT OUTER JOIN cannot be used without a condition that is an equality of fields from both sides of the join

I am executing following query and getting "LEFT OUTER JOIN cannot be used without a condition that is an equality of fields from both sides of the join".

select p.*, q.* from (      select a.* from table1 a      left join      (select distinct * from table2) b      on a.name1=b.name2      where a.name1 is not null) p  left join   (SELECT distinct name3, amount FROM table3) q  on q.name3=p.name1 or q.name3=p.name2   

How should I resolve it?

https://stackoverflow.com/questions/66040300/bigquery-issue-left-outer-join-cannot-be-used-without-a-condition-that-is-an-e February 04, 2021 at 02:20PM