Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Icon for Helper V rankHelper V
9 years ago

error in join

   
LuisQuedas's avatar
LuisQuedas
Icon for Advocate I rankAdvocate 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
      Icon for Microsoft Employee rankMicrosoft 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,