Forum Discussion

danilomorganti's avatar
danilomorganti
Frequent Visitor
6 years ago
Solved

Combine Table

Hi everyone! I need your help about combine 2 table without same column.

I have a table 1 (Calendar table) and Table 2 (List of Product).

I would like to build a table with, for every row in table 1 complete list of row in table 2.

 

Example :

Table 1

Col 1|Col2

01/01/2020|True

02/01/2002|False

03/01/2020|False

 

Table 2

Col 1

Item_1

Tem_2

Item_3

 

Result

Table1.Col 1|Table1.Col 2|Table2.Col 1

01/01/2020|True|Item_1

01/01/2020|True|Item_2

01/01/2020|True|Item_3

02/01/2020|False|Item_1

02/01/2020|False|Item_2

02/01/2020|False|Item_3

03/01/2020|False|Item_1

03/01/2020|False|Item_2

03/01/2020|False|Item_3

 

Thanks in advance

 

BR 

 

Danilo

2 Replies