I have been trying to join two tables from different datasets that are in different locations but in the same project. However, I keep getting the error:
dataset not found in US location.
The datasets' locations are US and us-east1
Here is what I am doing:
select a.*, b.* from `project.dataset1.table1` a join `project.dataset2.table2` on a.common_col = b.common_col
Please help me out on this.