Bigquery conditional join

Bigquery conditional join. .