📝[Docs]:Add Joins to SQL

[SaiSruthisri]

Is there an existing issue for this?

• I have searched the existing issues

Issue Description

Summary

The current SQL documentation lacks detailed notes on the topic "JOINS", making it harder for beginners to understand different join operations and their use cases. I would like to introduces comprehensive explanation notes for INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, and CROSS JOIN, with examples for each.

Suggested Change

What's will be Implemented ?

• Adding a new section "Understanding SQL Joins" under the SQL documentation.
• Covering following topics with explanations and syntax:
  • INNER JOIN
  • LEFT (OUTER) JOIN
  • RIGHT (OUTER) JOIN
  • FULL OUTER JOIN
  • CROSS JOIN
• Including diagrams and example queries for better visualization.
• Will try to include interactive join visualizations or playground examples for users to try queries live.
• Adding comparison table summarizing the differences between join types.
• Providing real-world examples to demonstrate practical usage of joins.

Rationale

Why This Change is Needed

• Improves the SQL docs by making them more beginner-friendly.
• Provides clear, structured content for quick learning and reference.
• Addresses a documentation gap for a core SQL concept.

Urgency

High

Record

• I have read the Contributing Guidelines
• Are you a GSSOC'25 contributor
• I want to work on this issue

[github-actions]

Thanks for opening this issue! 🎉 We'll look into it as soon as possible, estimated time for response is 5–8 hrs.

Don't raise PR unless assigned to you.

In the meantime, please provide all necessary details and context to your issue — screenshots or videos of your changes help speed up the review and assignment. If you have questions, reach out to LinkedIn. Your contributions are highly appreciated!😊

Note: I maintain the repo issue every day twice at 8:00 AM IST and 9:00 PM IST. If your issue goes stale for more than one day, you can tag and comment on this same issue by tagging @sanjay-kv.

We are here to help you on this journey of open source. Consistent contributions are eligible for sponsorship 💰

🎁 check our list of amazing people we sponsored so far: GitHub Sponsorship. ✨

📚Resources which can help you know more about Github 👇🏻

1. End to End GitHub Beginner Playlist: GitHub Playlist.

2. Build your GitHub Profile: GitHub Profile Optimisation.

3. GitHub Handbook for dummies: GitHub Blog for Beginners.

[github-actions]

👤 Issue assigned to @SaiSruthisri.

[Adez017]

Hi @sanjay-kv , if this issue is unresolved i would like to work upon this .

[sanjay-kv]

reassigned to you

[github-actions]

👤 Issue assigned to @Adez017.