how to combine data

[SeanZ]

I have two datasets and want to combine them together. Please see below.

dataset A

firm

1

2

3

...

dataset B

date

a

b

c

I want to have a dataset C, which looks like

dataset C

firm     date

1          a

1          b

1          c

2          a

2          b

2          c

3          a

3          b

3          c

....

How to achieve this? Thanks.

[LinusH · Accepted solution]

Just use SQL without any join condition.