error in join

[Satish_Kumar]

[LaurentCouartou]

It looks like both tables in your CROSSJOIN have a column named 'No_'.

This is not allowed, because the returned tables would have two columns with the same name.

Try to restrict the number of columns that participate in the CROSSJOIN operation with a GROUPBY / SUMMARIZE or use SELECTCOLUMNS to rename some columns.

[LuisQuedas]

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

[Satish_Kumar]

@LuisQuedas Nothing Changes it is showing same error.

[v-sihou-msft]

@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,

[Satish_Kumar]

[Satish_Kumar]

Error while Cross JoinTable oneTable two

[BhaveshPatel]

Hi Satish,

Can you please repost the screenshots. I can not see anything in the screenshots.

[Satish_Kumar]

@BhaveshPatel i already posted the new screen shot.

with new post "Error in Join" just a few seconds earlier.