New table using existing tables

[AMRM_342]

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

[misaki233 · Accepted solution]

Hi @AMRM_342 ,

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

[AMRM_342]

Great, it worked. Thanks