Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Helper V
9 years ago

error in join

   
LuisQuedas's avatar
LuisQuedas
Advocate I
9 years ago

Hi Satish,

 

Do this two tables already have a bidirectional relationship between them? if so, try to remove that bidirectional relationship and try the crossjoin again.

 

Cheers, Luis

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    Satish_Kumar

     

    As the error message said, "No_" column exists in both tables. When using CROSSJOIN() function, column names from table arguments must all be different in all tables or an error is returned. Otherwise it can't do Cartesian. Please verify the columns in both tables. If both contains "No_" columns, you can join these to tables using "Merge Queries" in Query Editor.

     

     

    Regards,