🔗 Oracle SQL Joins

This repository contains practical SQL queries demonstrating various types of table joins using Oracle Database. It's designed as a hands-on lab to help students and professionals understand how to retrieve and relate data across multiple tables.

📘 Topics Covered

The lab covers 12 types of joins with full solutions and comments:

1. ✅ Natural Join
2. ✅ Join with the USING Clause
3. ✅ Join with the ON Clause
4. ✅ Self-Join
5. ✅ Non-Equijoins
6. ✅ LEFT OUTER Join
7. ✅ RIGHT OUTER Join
8. ✅ FULL OUTER Join
9. ✅ CROSS Join (Cartesian Product)
10. ✅ Three-Way Join using ON
11. ✅ Join with Additional Conditions
12. ✅ Table Aliases with Joins

---

🧾 File Details

• joins_lab.sql – Contains all queries with:
  • Question numbers and headings as comments
  • Clear formatting and table aliases
  • Educational purpose queries with expected logic

---

🛠️ Tools Used

• 💾 Oracle SQL Developer
• 🧩 Oracle Server (Live/Local)
• 💻 Structured Query Language (SQL)

---

🎓 Learning Outcomes

By completing this lab, you will be able to:

• Write SQL queries that combine data from multiple tables
• Understand INNER, OUTER, and CROSS joins
• Use USING, ON, and aliases to simplify code
• Perform advanced queries like self-joins and non-equijoins

---

📸 Screenshots (Optional)

---

📎 How to Use

1. Clone this repository

git clone https://github.com/YourUsername/oracle-sql-joins-lab.git

!

📬 Connect with Me
👤 Linkedin : Awais Manzoor
📧 awaismanzor125@gmail.com