# 177|SQL – Intro to Join Statements

**URL:** <https://www.techhub.training/t/177-sql-intro-to-join-statements/2641>\
**Category:** Challenges\
**Tags:** managerial, sql, intro, learningpath\
**Created:** [April 30, 2024, 12:56am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641 "2024-04-30T00:56:22Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![Cannon\_Hamilton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cannon_hamilton/32/7390_2.png) [@Cannon\_Hamilton](https://www.techhub.training/u/Cannon_Hamilton)\
**Post date:** [February 24, 2025, 2:03am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/22 "2025-02-24T02:03:13Z")

</div>

Q1: SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders AS o  
INNER JOIN Employee AS e ON o.emp\_order\_creation\_id=e.Employee\_ID;

Q2: SELECT v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM Inventory AS i  
LEFT JOIN Vendor AS v ON i.preferred\_vendor=v.vendor\_id;

Q3: SELECT i.order\_id, i.payable\_amount  
FROM Invoice AS i;

Q4: SELECT Inventory.inventory\_name, Vendor.company\_name, Invoice.emp\_received\_id, Invoice.invoice\_receipt\_date  
FROM (Inventory  
INNER JOIN Vendor ON Inventory.preferred\_vendor=Vendor.vendor\_id)  
INNER JOIN Invoice ON Vendor.vendor\_id=Invoice.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Rylee\_Schriever](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/rylee_schriever/32/6914_2.png) [@Rylee\_Schriever](https://www.techhub.training/u/Rylee_Schriever)\
**Post date:** [February 24, 2025, 4:21am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/23 "2025-02-24T04:21:33Z")

</div>

20 minutes  
median  
Enjoyed this challenge!

1. SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders o INNER JOIN Employee e ON o.emp\_order\_creation\_id = e.Employee\_ID;

2. SELECT v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM Inventory i INNER JOIN Vendor v ON i.preferred\_vendor=v.vendor\_id;

3. SELECT i.order\_id, i.payable\_amount  
FROM Invoice AS i;

4. 

SELECT Inventory.inventory\_name,Vendor.company\_name, Invoice.emp\_received\_id, Invoice.invoice\_receipt\_date  
FROM( (Inventory  
INNER JOIN Vendor ON Inventory.preferred\_vendor=Vendor.vendor\_id)  
INNER JOIN Invoice ON Invoice.vendor\_id=Vendor.vendor\_id)  
;

---

<div class="post-metadata">

**Author:** ![Nate\_Hansen](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/nate_hansen/32/7389_2.png) [@Nate\_Hansen](https://www.techhub.training/u/Nate_Hansen)\
**Post date:** [February 24, 2025, 5:14am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/24 "2025-02-24T05:14:02Z")

</div>

Time to complete: 25 min  
Rating: Medium  
Comments: FUN!

1. SELECT Orders.order\_id, first\_name, last\_name  
FROM Orders  
INNER JOIN Employee ON Employee.employee\_id = Orders.emp\_order\_creation\_id;

2. SELECT vendor.company\_name, inventory.inventory\_name, inventory.std\_order\_qty  
FROM Inventory  
Inner Join Vendor ON Inventory.preferred\_vendor = Vendor.vendor\_id;

3. SELECT order\_id, payable\_amount  
FROM Invoice;

4. SELECT i.inventory\_name, v.Company\_name, INV.emp\_received\_id, INV.invoice\_receipt\_date  
FROM ( Inventory AS I INNER JOIN Vendor AS V ON i.Preferred\_Vendor = V.Vendor\_id )  
INNER JOIN Invoice AS INV ON V.Vendor\_id = INV.Vendor\_id;

---

<div class="post-metadata">

**Author:** ![Gavin\_Ross](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/gavin_ross/32/7071_2.png) [@Gavin\_Ross](https://www.techhub.training/u/Gavin_Ross)\
**Post date:** [February 24, 2025, 6:14am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/25 "2025-02-24T06:14:09Z")

</div>

Time to complete: 15 mins  
Rating: Beginner  
Solution:

1. SELECT Orders.order\_id, Employee.first\_name, Employee.last\_name  
FROM Orders INNER JOIN Employee ON Orders.emp\_order\_creation\_id = Employee.employee\_id;

2. SELECT Vendor.company\_name, Inventory.inventory\_name, Inventory.std\_order\_qty  
FROM Vendor INNER JOIN Inventory ON Inventory.preferred\_vendor = Vendor.vendor\_id;

3. SELECT order\_id, payable\_amount  
FROM Invoice;

4. SELECT Inventory.inventory\_name, Vendor.company\_name, Invoice.emp\_received\_id, Invoice.invoice\_receipt\_date  
FROM (Inventory INNER JOIN Vendor ON Inventory.preferred\_vendor = Vendor.vendor\_id)  
INNER JOIN Invoice ON Vendor.vendor\_id = Invoice.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Katie\_Kim](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/katie_kim/32/7392_2.png) [@Katie\_Kim](https://www.techhub.training/u/Katie_Kim)\
**Post date:** [February 24, 2025, 7:34am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/26 "2025-02-24T07:34:10Z")

</div>

Time to complete: 15 Minutes  
Difficulty: Easy

Solutions:

1. SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Employee AS e  
INNER JOIN Orders AS o ON o.emp\_order\_creation\_id=e.Employee\_ID;
2. SELECT v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM Inventory AS i  
INNER JOIN Vendor AS v ON i.preferred\_vendor = v.vendor\_id;
3. SELECT order\_id, payable\_amount FROM Invoice;
4. SELECT i.inventory\_name, v.company\_name, inv.emp\_received\_id, inv.invoice\_receipt\_date  
FROM (Inventory AS i  
INNER JOIN Vendor AS V ON i.Preferred\_Vendor = v.vendor\_id)  
INNER JOIN Invoice as inv ON v.vendor\_id = inv.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Faith\_Bangerter](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/faith_bangerter/32/7395_2.png) [@Faith\_Bangerter](https://www.techhub.training/u/Faith_Bangerter)\
**Post date:** [February 24, 2025, 6:52pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/27 "2025-02-24T18:52:56Z")

</div>

Time to complete: 25 Minutes  
Difficulty: Beginner

1. SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders AS o  
INNER JOIN Employee AS e ON o.emp\_order\_creation\_id = e.employee\_id;

2. SELECT v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM Vendor AS v  
INNER JOIN Inventory AS i ON i.preferred\_vendor = v.vendor\_id;

3. SELECT order\_id, payable\_amount  
FROM Invoice;

4. SELECT i.inventory\_name, v.company\_name, inv.emp\_received\_id, inv.invoice\_receipt\_date  
FROM (Inventory AS i INNER JOIN Vendor AS v ON i.preferred\_vendor = v.vendor\_id)  
INNER JOIN Invoice AS inv ON v.vendor\_id = inv.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Lilia\_Fisher](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/lilia_fisher/32/7394_2.png) [@Lilia\_Fisher](https://www.techhub.training/u/Lilia_Fisher)\
**Post date:** [February 24, 2025, 6:53pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/28 "2025-02-24T18:53:55Z")

</div>

Time to complete: 15  
Rating: Intermediate  
Interesting to see when you can use Inner join and Left join, etc.

1. SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders AS o  
INNER JOIN Employee AS e  
ON o.emp\_order\_creation\_id = e.Employee\_ID;  
2.SELECT v.company\_name,i.inventory\_name, i.std\_order\_qty  
FROM Inventory as i  
LEFT JOIN Vendor as v ON i.preferred\_vendor = v.vendor\_id;  
3.SELECT Order\_id, Payable\_amount  
FROM Invoice;
2. SELECT Inventory.inventory\_name, Vendor.company\_name, Invoice.emp\_received\_id, Invoice.invoice\_receipt\_date  
FROM (Vendor INNER JOIN Inventory ON Vendor.vendor\_id = Inventory.preferred\_vendor) INNER JOIN Invoice ON Vendor.vendor\_id = Invoice.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Jacob\_Sumsion](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jacob_sumsion/32/7396_2.png) [@Jacob\_Sumsion](https://www.techhub.training/u/Jacob_Sumsion)\
**Post date:** [February 24, 2025, 7:07pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/29 "2025-02-24T19:07:15Z")

</div>

Time to complete: 20 mins  
rating: Intermediate

Solutions:

Q1  
SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Employee AS e  
INNER JOIN Orders AS o ON o.emp\_order\_creation\_id = e.Employee\_ID;

Q2  
Select v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM Vendor AS v  
INNER JOIN Inventory AS i ON i.preferred\_vendor = v.vendor\_id;

Q3  
SELECT o.order\_id, inv.payable\_amount  
FROM Orders AS o  
INNER JOIN Invoice AS inv ON o.order\_id = inv.order\_id;

Q4  
SELECT inventory\_name, company\_name, emp\_received\_id, invoice\_receipt\_date  
FROM (Inventory  
INNER JOIN Vendor ON Inventory.preferred\_vendor=Vendor.vendor\_id)  
INNER JOIN Invoice ON Vendor.vendor\_id=Invoice.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Ian\_Bonine](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/ian_bonine/32/6911_2.png) [@Ian\_Bonine](https://www.techhub.training/u/Ian_Bonine)\
**Post date:** [February 24, 2025, 7:20pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/30 "2025-02-24T19:20:24Z")

</div>

Time to complete: 20 Minutes  
Difficulty: medium  
Notes: Good problems

1, SELECT O.order\_id, E.first\_name, E.last\_name  
FROM Employee AS E  
INNER JOIN Orders AS O ON E.employee\_id = O.emp\_order\_creation\_id;

2,  
SELECT Vendor.company\_name, Inventory.inventory\_name, Inventory.std\_order\_qty  
FROM Vendor  
INNER JOIN Inventory ON Vendor.vendor\_id = Inventory.preferred\_vendor;

3,  
SELECT Orders.order\_id, Invoice.payable\_amount  
FROM Orders INNER JOIN Invoice ON Orders.order\_id = Invoice.order\_id;

4,  
SELECT Inventory.inventory\_name, Vendor.company\_name, Invoice.emp\_received\_id, Invoice.invoice\_receipt\_date  
FROM (Vendor  
INNER JOIN Inventory ON Vendor.vendor\_id = Inventory.preferred\_vendor)  
INNER JOIN Invoice ON Vendor.vendor\_id = Invoice.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Connor\_Smith](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/connor_smith/32/7397_2.png) [@Connor\_Smith](https://www.techhub.training/u/Connor_Smith)\
**Post date:** [February 24, 2025, 9:23pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/31 "2025-02-24T21:23:25Z")

</div>

Time to Complete: 15 minutes  
Difficulty: Easy  
Solution:  
1.SELECT Orders.order\_id, Employee.first\_name, Employee.last\_name  
From Orders  
Inner Join Employee on Orders.emp\_order\_creation\_id=Employee.Employee\_ID;  
2.SELECT Vendor.company\_name, Inventory.inventory\_name, Inventory.std\_order\_qty  
From Vendor  
Right Join Inventory on Vendor.vendor\_id=Inventory.preferred\_vendor;  
3.SELECT order\_id, payable\_amount  
From Invoice ;  
4.SELECT Inventory.inventory\_name, Vendor.company\_name, Invoice.emp\_received\_id, Invoice.invoice\_receipt\_date  
From (Inventory Right Join Vendor on Inventory.preferred\_vendor=Vendor.vendor\_id)  
Right Join Invoice on Vendor.vendor\_id=Invoice.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Katelyn\_Hamilton](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/katelyn_hamilton/32/7398_2.png) [@Katelyn\_Hamilton](https://www.techhub.training/u/Katelyn_Hamilton)\
**Post date:** [February 24, 2025, 9:46pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/32 "2025-02-24T21:46:54Z")

</div>

Time to complete: 20 minutes  
Difficulty: Easy  
Solution:

1. SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders o  
INNER JOIN Employee e ON o.emp\_order\_creation\_id=e.Employee\_ID;
2. SELECT v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM Inventory i  
LEFT JOIN Vendor v ON i.preferred\_vendor=v.vendor\_id;
3. SELECT order\_id, payable\_amount  
FROM Invoice;
4. SELECT i.inventory\_name, v.company\_name, inv.emp\_received\_id, inv.invoice\_receipt\_date  
FROM (Inventory i INNER JOIN Vendor v ON i.preferred\_vendor=v.vendor\_id)  
INNER JOIN Invoice inv ON v.vendor\_id=inv.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Andrew\_Wells](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/andrew_wells/32/7399_2.png) [@Andrew\_Wells](https://www.techhub.training/u/Andrew_Wells)\
**Post date:** [February 24, 2025, 9:56pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/33 "2025-02-24T21:56:22Z")

</div>

Time to complete: 25 minutes  
Rating: moderate  
Solutions:  
1.  
SELECT Orders.order\_id, Employee.first\_name, Employee.last\_name  
FROM Orders  
INNER JOIN Employee ON Orders.emp\_order\_creation = Employee.employee\_id;  
2.  
SELECT Vendor.company\_name, Inventory.inventory\_name, Inventory.std\_order\_qty  
FROM Inventory  
LEFT JOIN Vendor ON Inventory.preferred\_vendor = Vendor.vendor\_id;  
3.  
SELECT order\_id, payable\_amount  
FROM Invoice  
4.  
SELECT Inventory.Inventory\_Name, Vendor.Company\_Name, Invoice.emp\_received\_ID, Invoice.Invoice\_Receipt\_Date  
FROM (Inventory INNER JOIN Vendor ON Inventory.preferred\_vendor = Vendor.vendor\_ID) INNER JOIN Invoice ON Vendor.vendor\_ID = Invoice.vendor\_ID;

---

<div class="post-metadata">

**Author:** ![Rachel\_Lopez](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/rachel_lopez/32/7388_2.png) [@Rachel\_Lopez](https://www.techhub.training/u/Rachel_Lopez)\
**Post date:** [February 24, 2025, 10:16pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/34 "2025-02-24T22:16:18Z")

</div>

Time to Complete: ~20 Minutes  
Rating: Intermediate

Q1: SELECT Orders.order\_id, Employee.first\_name, Employee.last\_name  
FROM Orders INNER JOIN Employee ON Orders.emp\_order\_creation\_id = Employee.employee\_id;

Q2: SELECT Vendor.company\_name, Inventory.inventory\_id, Inventory.std\_order\_qty  
FROM Inventory INNER JOIN Vendor ON Inventory.preferred\_vendor = Vendor.vendor\_id;

Q3: SELECT order\_id, payable\_amount  
FROM Invoice;

Q4: SELECT Inventory.inventory\_name, Vendor.company\_name, Invoice.emp\_received\_id, Invoice.invoice\_receipt\_date  
FROM (Inventory INNER JOIN Vendor ON Inventory.preferred\_vendor = Vendor.vendor\_id) INNER JOIN Invoice ON Vendor.vendor\_id = Invoice.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Molly\_Pratt](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/molly_pratt/32/7400_2.png) [@Molly\_Pratt](https://www.techhub.training/u/Molly_Pratt)\
**Post date:** [February 24, 2025, 10:42pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/35 "2025-02-24T22:42:26Z")

</div>

Time to Complete: 15 minutes  
Difficulty: Easy  
Solution:

1: SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders AS o INNER JOIN Employee AS e ON o.emp\_order\_creation\_id=e.Employee\_ID;

2: SELECT v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM Inventory as i LEFT JOIN Vendor as v ON i.preferred\_vendor=v.vendor\_id;

3: SELECT iv.order\_id, iv.payable\_amount  
FROM Invoice AS iv;

4: SELECT i.inventory\_name, v.company\_name, iv.emp\_received\_id, iv.invoice\_receipt\_date  
FROM (Inventory as i INNER JOIN Vendor as v ON i.preferred\_vendor=v.vendor\_id)  
INNER JOIN Invoice as iv ON v.vendor\_id=iv.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Tyson\_Yee](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/tyson_yee/32/7401_2.png) [@Tyson\_Yee](https://www.techhub.training/u/Tyson_Yee)\
**Post date:** [February 24, 2025, 11:10pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/36 "2025-02-24T23:10:21Z")

</div>

Time to Complete: 15 minutes  
Rating: Beginner  
Notes: Enjoyed the challenge!  
Solutions:

1. SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders AS o  
INNER JOIN Employee AS e ON o.emp\_order\_creation\_id = e.employee\_id;

2. SELECT v.company\_name, i.inventory\_id, i.std\_order\_qty  
FROM Inventory AS i  
LEFT JOIN Vendor AS v ON i.preferred\_vendor = v.vendor\_id;

3. SELECT order\_id, payable\_amount  
FROM Invoice;

4. SELECT i.inventory\_name, v.company\_name, inv.emp\_received\_id, inv.invoice\_receipt\_date  
FROM (Inventory AS i INNER JOIN Vendor AS v ON i.preferred\_vendor = v.vendor\_id)  
INNER JOIN Invoice AS inv ON v.vendor\_id = inv.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Chris\_Sosa](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/chris_sosa/32/7375_2.png) [@Chris\_Sosa](https://www.techhub.training/u/Chris_Sosa)\
**Post date:** [February 24, 2025, 11:39pm UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/37 "2025-02-24T23:39:42Z")

</div>

Time to complete: 10 minutes  
Difficulty: Beginner

1. SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders as o  
INNER JOIN Employee as e ON o.emp\_order\_creation\_id = e.employee\_id;  
2.SELECT v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM Vendor as v  
INNER JOIN Inventory as i ON v.vendor\_id = i.preferred\_vendor;  
3.SELECT i.order\_id, i.payable\_amount  
FROM Invoice as i;  
4.SELECT inventory\_name, company\_name, emp\_received\_id, invoice\_receipt\_date  
FROM (Inventory INNER JOIN Vendor ON Inventory.preferred\_vendor = Vendor.vendor\_id)  
INNER JOIN Invoice ON Vendor.vendor\_id = Invoice.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Hailey\_Smith](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/hailey_smith/32/7077_2.png) [@Hailey\_Smith](https://www.techhub.training/u/Hailey_Smith)\
**Post date:** [February 25, 2025, 12:06am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/38 "2025-02-25T00:06:34Z")

</div>

Time: 25 minutes  
Difficulty: Medium  
1:  
SELECT order\_id, first\_name, last\_name  
FROM Employee e  
INNER JOIN Orders o ON e.employee\_id = o.emp\_order\_creation\_id;

2:  
SELECT company\_name, inventory\_name, std\_order\_qty  
FROM Inventory i  
INNER JOIN Vendor v ON v.vendor\_id = i.preferred\_vendor;

3:  
SELECT order\_id, payable\_amount  
FROM Invoice;

4:  
SELECT Inventory.inventory\_name, Vendor.company\_name, Invoice.emp\_received\_id, Invoice.invoice\_receipt\_date  
FROM (Inventory INNER JOIN Vendor ON Inventory.preferred\_vendor = Vendor.vendor\_id)  
INNER JOIN Invoice ON Vendor.vendor\_id = Invoice.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Preston\_Dudley](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/preston_dudley/32/7403_2.png) [@Preston\_Dudley](https://www.techhub.training/u/Preston_Dudley)\
**Post date:** [February 25, 2025, 12:17am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/39 "2025-02-25T00:17:44Z")

</div>

Time to complete: 15 minutes  
Difficulty: Beginner  
Notes: Just forgot about the parenthesis in the last one

Q1:  
SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders o  
INNER JOIN Employee e ON o.emp\_order\_creation\_id=e.Employee\_ID;

Q2:  
SELECT v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM vendor v  
INNER JOIN Inventory i ON v.vendor\_id = i.preferred\_vendor;

Q3:  
SELECT order\_id, payable\_amount  
FROM Invoice;

Q4:  
SELECT i.inventory\_name, v.company\_name, c.emp\_received\_id, c.invoice\_receipt\_date  
FROM (Inventory i INNER JOIN Vendor v ON v.vendor\_id = i.preferred\_vendor)  
INNER JOIN Invoice c ON c.vendor\_id = v.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Charlotte\_Owsley](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/charlotte_owsley/32/6929_2.png) [@Charlotte\_Owsley](https://www.techhub.training/u/Charlotte_Owsley)\
**Post date:** [February 25, 2025, 12:27am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/40 "2025-02-25T00:27:33Z")

</div>

Time to complete 25 minutes  
Q1  
SELECT o.order\_id, e.first\_name, e.last\_name  
FROM Orders AS o INNER JOIN Employee AS e ON o.emp\_order\_creation\_id = e.employee\_id;

Q2  
SELECT v.company\_name, i.inventory\_name, i.std\_order\_qty  
FROM Inventory AS i  
INNER JOIN Vendor AS v ON i.preferred\_vendor = v.vendor\_ID;

Q3  
SELECT o.order\_id, i.payable\_amount  
FROM Orders AS o LEFT JOIN Invoice AS i ON o.order\_id = i.order\_id;

Q4  
SELECT  
i.inventory\_name,  
v.company\_name,  
inv.emp\_received\_id,  
inv.invoice\_receipt\_date  
FROM (((Invoice AS inv  
INNER JOIN Orders AS o ON inv.order\_id = o.order\_id)  
INNER JOIN OrderDetail AS od ON o.order\_id = od.order\_id)  
INNER JOIN Inventory AS i ON od.inventory\_id = i.inventory\_id)  
INNER JOIN Vendor AS v ON inv.vendor\_id = v.vendor\_id  
WHERE i.preferred\_vendor = v.vendor\_id;

---

<div class="post-metadata">

**Author:** ![Kylie\_Eaquinto](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kylie_eaquinto/32/7404_2.png) [@Kylie\_Eaquinto](https://www.techhub.training/u/Kylie_Eaquinto)\
**Post date:** [February 25, 2025, 1:22am UTC](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641/41 "2025-02-25T01:22:32Z")

</div>

Time to complete: 20 Minutes  
Difficulty: Moderate  
1: SELECT orders.order\_id, employee.first\_name, employee.last\_name  
FROM orders INNER JOIN employee ON Orders.emp\_order\_creation\_id=Employee.Employee\_ID;  
2: SELECT company\_name, inventory\_name, std\_order\_qty FROM inventory INNER JOIN vendor ON inventory.preferred\_vendor=vendor.vendor\_id;  
3: SELECT order\_id, payable\_amount  
FROM invoice;  
4: SELECT inventory\_name, company\_name, emp\_received\_id, invoice\_receipt\_date  
FROM ((inventory as i INNER JOIN vendor as v ON i.preferred\_vendor=v.vendor\_id) INNER JOIN invoice as iv ON v.vendor\_id=iv.vendor\_id);

[Previous page](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641.md?page=1)

[Next page](https://www.techhub.training/t/177-sql-intro-to-join-statements/2641.md?page=3)