Can query tables from different datasets in BigQuery

Question

In Google BigQuery, can a query joins two tables in different datasets? say If I want to join these two tables, what should I do? dataset1:table1 and dataset2:table2

Thank you

Answer 1

#standardSQL
SELECT <fields list>
FROM `project.dataset1.table1` t1
JOIN `project.dataset2.table2` t2
ON t1.id = t2.id   

see more about JOINs in documentation