Question

Using inner join, list the details of the products whose line price is greater than 100. what command we will use in sql?

Answer 1

Hi,

Please find the answer below:
-----------------------------

The JOIN operator is used to join tables in SQL query language. INNER JOIN is used
to specify the matching values in the join condition.
The ON clause is used to specify the condition for the participating tables on the JOIN condition.

General steps for joining the tables in SQL:

• Examine the tables.
• Decide on what columns you want to display in the query result.
• Identify common columns.
• JOIN condition. Usually the equality of the common columns.
• Identify the filter condition. WHERE clause.

Sample SQL query using INNER JOIN

Example of joining products and categories using the INNER JOIN clause.

-----------------

SELECT Products.Name, Products.Price, Categories.CategoryName
FROM Products
INNER JOIN Categories
ON Categories.CategoryID=Products.CategoryID
WHERE Products.Price > 100 ;

------------------

Note: For the exact query provide the table's schema.

Hope this helps.