Select name_of_lumn_name1, name_of_lumn_name2, …, name_of_lumn_nameN name_of_lumn_name1, name_of_lumn_name2, …., name_of_lumn_nameN from name_of_table1 CROSS JOIN name_of_table2 column_name = name_of_lumn_name ĥ) Join the redshift table using cross join Select name_of_lumn_name1, name_of_lumn_name2, …, name_of_lumn_nameN name_of_lumn_name1, name_of_lumn_name2, …., name_of_lumn_nameN from name_of_table1 FULL OUTER JOIN name_of_table2 ON name_of_table1. column_name = name_of_lumn_name Ĥ) Join the redshift table using full outer join Select name_of_lumn_name1, name_of_lumn_name2, …, name_of_lumn_nameN name_of_lumn_name1, name_of_lumn_name2, …., name_of_lumn_nameN from name_of_table1 RIGHT OUTER JOIN name_of_table2 ON name_of_table1. 3) Join the redshift table using right outer join
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |