2. Nested Subqueries
INNER JOIN is a join that will join only those records from two tables that contain the same values in the column being joined. It will be easier to understand on the gif. Please, watch it.
Let's take a look at the syntax.
In this section, we are going to work with the
product database. It contains the following two tables:
price. Let's take a look at them closer and learn their connections.
Let's look at the first table -
Let's look at the second table -
JOINhave the same functionality in SQL and can be used interchangeably to join tables based on a specified condition.
It is time to practice!
- You need to retrieve the names (
namecolumn from the
- Retrieve the price (
pricetable) of the products whose price exceeds $10;
- For it you have to join these tables using the
- Please start with the
producttable and then join the
Everything was clear?