been trying to join two tables in different data set which are in different locations but in same project. Always getting an error that
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 in this?