Please find the below provided query which I'm able to implement in Netezza where in case there is no join on 'id' then it looks for the join on the basis of 'name'. if any of the criteria gets fulfilled then Left outer join is performed.

```
Select * from BigqueryTest.colors a 
LEFT JOIN 
BigqueryTest.color2 b
ON a.id = b.id
OR a.name = b.name ;

```

This functionality doesn't seem to be supported in Bigquery. I mean to say that I can provide multiple joining conditions with the help of 'AND' operator but can't use 'OR' operator which can allow me moving ahead with Join operation even if a single condition gets satisfied out of many. Any leads would be appreciated.