R
R
Roman Rofl2021-04-13 22:22:40
SQL
Roman Rofl, 2021-04-13 22:22:40

How to do a subquery in sql help?

w3schools.com
Task Display all products with product code >= 64 or products with supplier = "Tokyo Traders" (subquery).

SELECT * FROM [Products] WHERE
ProductID >= 64 please tell me the link( https://www.w3schools.com/sql/trysql.asp?filename=... )

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
StiflerProger, 2021-04-13
@StiflerProger

SELECT * FROM [Products]
LEFT JOIN [Suppliers] ON Suppliers.SupplierID = Products.SupplierID
WHERE ProductID >=64 OR SupplierName="Tokyo Traders"

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question