Scribd
Upload
2 views5 pages

SQL

The document contains multiple SQL SELECT queries that retrieve data from various tables including Customers, Orders, Shippers, Products, Categories, and Suppliers. Each query performs INNER JOIN operations to combine related data and orders the results based on specified criteria. The queries aim to extract customer names, order details, product names, and supplier information.

Uploaded by

qadiraleee19
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views5 pages

SQL

The document contains multiple SQL SELECT queries that retrieve data from various tables including Customers, Orders, Shippers, Products, Categories, and Suppliers. Each query performs INNER JOIN operations to combine related data and orders the results based on specified criteria. The queries aim to extract customer names, order details, product names, and supplier information.

Uploaded by

qadiraleee19
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SELECT

[Link] AS CustomerName,
[Link],
[Link],
[Link]
FROM
Customers
INNER JOIN Orders
ON [Link] = [Link]
INNER JOIN Shippers
ON [Link] = [Link]
ORDER BY
[Link], [Link];
SELECT
[Link] AS CustomerName,
[Link],
[Link]
FROM
Customers
INNER JOIN Orders
ON [Link] = [Link]
ORDER BY
[Link];
SELECT
[Link],
[Link],
[Link]
FROM
Orders
INNER JOIN Shippers
ON [Link] = [Link]
ORDER BY
[Link] DESC;
SELECT
[Link],
[Link]
FROM
Products
INNER JOIN Categories
ON [Link] = [Link]
ORDER BY
[Link], [Link];
SELECT
[Link],
[Link],
[Link]
FROM
Products
INNER JOIN Suppliers
ON [Link] = [Link]
ORDER BY
[Link];

You might also like