Joining tables from different locations in Bigquery 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?
You can't join two tables in different data set which are in different locations. As an alternative solution, you can copy datasets between regions using BigQuery Data Transfer Service. Here is the documentation link Copying Datasets:
bq mk --transfer_config \
      --project_id=myproject \
      --data_source=cross_region_copy \
      --target_dataset=dataset_us \
      --display_name='Copy Dataset' \
      --params='{&quot;source_dataset_id&quot;:&quot;dataset_eu&quot;,&quot;source_project_id&quot;:&quot;myproject&quot;}'