SQL join on joint query instance

SQL join on joint query instance

SQL join-use join
In addition to the above method, we can also use the keyword join to obtain data from two tables.

If we want to list the orders of all users, we can use the following select statement:

Select persons. lastname, persons. firstname, orders. orderno
From persons
Inner join orders
On persons. id_p = orders. id_p

Instance 2

Select title, artist
From album join track
On (album. asin = track. album)
Where song = 'alison'

Reference two tables
We can obtain data from two tables by referencing two tables:

Who ordered the product and what product they ordered?

Select persons. lastname, persons. firstname, orders. orderno
From persons, orders
Where persons. id_p = orders. id_p

SQL join is used to query data from two or more tables based on the relationship between columns.