join data in sql
#Joining 2 tables: table_1 and table_1
#Select the all the columns you want to show in the final joined table.
SELECT
table_1.column_a,
table_2.column_b
#Select the first table
FROM
database_name.table_1
#Select the type of join statement and second table you want to join.
JOIN
database_name.table_2
#Select the related columns on which you want to join the tables.
ON
table_1.column_a = table_2.column_b