JOIN clause https://developers.google.com/bigquery/query-reference#joins
SELECT field_1 [..., field_n] FROM
table_1 [[AS] alias_1]
[[INNER|LEFT OUTER|CROSS] JOIN [EACH]
table_2 [[AS] alias_2]
[ON join_condition_1 [... AND join_condition_n]]
]+