Forum Discussion

8 Replies

    • BhaveshPatel's avatar
      BhaveshPatel
      Super User
      9 years ago

      Hi Satish,

       

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

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

         

  • LaurentCouartou's avatar
    LaurentCouartou
    Solution Supplier
    9 years ago

    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.