how to combine data

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 122
Accepted Solution

how to combine data

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.


Accepted Solutions
Solution
‎11-03-2013 04:27 AM
Super User
Posts: 5,257

Re: how to combine data

Just use SQL without any join condition.

Data never sleeps

View solution in original post


All Replies
Solution
‎11-03-2013 04:27 AM
Super User
Posts: 5,257

Re: how to combine data

Just use SQL without any join condition.

Data never sleeps
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 145 views
  • 0 likes
  • 2 in conversation