Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

New table using existing tables

I have two tables. One has a list of companies with some other columns associated to each company, and the second one has only one column with categories.

I would like to create a third table, where table 1 is repeated for each category in table 2. Something like this

Any idea how can I do that?

Thank you in advance

 

  • Hi Anonymous ,

     

    Try to use function CROSSJOIN() between these two tables.

     

2 Replies

  • Hi Anonymous ,

     

    Try to use function CROSSJOIN() between these two tables.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Great, it worked. Thanks