New column with values from another table

[Syndicate_Admin]

Hello.

I have a table (Table A) with different columns which has a date column and I need another column (LT) with values from another table (Table B).

Table A:

Date	Week
06/02/2023	202306
13/03/2023	202311

Table B:

A	DESC
001	a
002	b
003	c

Final table A:

Date	Week	LT
06/02/2023	202306	001
06/02/2023	202306	002
06/02/2023	202306	003
13/03/2023	202311	001
13/03/2023	202311	002
13/03/2023	202311	003

Thank you.

[Syndicate_Admin]

Thank you but I do not want another table. I want to add a new column to table A with values from column LT from table B. Is it possible?

[amitchandak]

@Syndicate_Admin , use generate or crossjoin

generate(Table1, Table2)