Everybody good: I have two tables
A table data inside A: column 1
A
B

B: another table of data column 1
1
2
3

Now want to achieve: create a new table C:
Column 1 column 2
A 1
A 2
A 3
B 1
2 b
3 b

Could you tell me how to achieve to? Thank you for the

CodePudding user response:

Column 1 as the column 1, select a. b. column 1 as the column 2 from A, B