Answer the question
In order to leave comments, you need to log in
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
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 questionAsk a Question
731 491 924 answers to any question