Answered: Write a SELECT statement that will…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Write a SELECT statement that will return the distinct
productid and productname from the products table. Join
this to the suppliers table and join on supplierid. Also join the
Order Details where the productid is equal. We will obtain
the productid from a subquery on order details when the
productid is greater than one. Order by productname and
productid. (This will return 76 rows)

Expert Solution

Step 1

SQL query:

SELECT DISTINCT products.productid, products.productname, orders.order_details from products, suppliers, orders where products.supplierid=suppliers.supplierid AND products.productid=orders.productid order by productname AND productid;

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions