Forum Discussion
Anonymous
4 years agoNot applicable
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
- misaki233Helper II
Hi Anonymous ,
Try to use function CROSSJOIN() between these two tables.
- AnonymousNot applicable
Great, it worked. Thanks