Generating a table from two existing ones

[Sundi]

Dear all, need some help with the following.

I have a Date Table 

Date

1/1/2021

1/2/2021

1/3/2021

1/4/2021

1/5/2021

1/6/2021

1/7/2021

1/8/2021

1/9/2021

And I have a Table that holds stock tickers

Ticker

AAA

BBB

CCC

DDD

EEE

I would like to generate a Table that holds all tickers for each date:

New Table
Date	Ticker
1/1/2021	AAA
1/1/2021	BBB
1/1/2021	CCC
1/1/2021	DDD
1/1/2021	EEE
1/2/2021	AAA
1/2/2021	BBB
1/2/2021	CCC
1/2/2021	DDD
1/2/2021	EEE

[justISO]

Hi, just join these two tables. Like:

NoConcatenate
New_table:
LOAD Date
RESIDENT your_Date_table;

JOIN
LOAD Ticker
RESIDENT your_Ticker_table;

DROP TABLES your_Date_table, your_Ticker_table;