Database Management System (DBMS) / SQL(STRUCTURED QUERY LANGUAGE)

JOIN without using JOIN keywords

Joins can be done even without writing the JOIN Keyword but using WHERE clause!

📌 This gives the same result as an INNER JOIN.

⚠️ Limitations

  • ❌ You cannot use LEFT JOIN, RIGHT JOIN, or FULL OUTER JOIN with this syntax

  • ✅ Only supports INNER JOIN

  • 🧼 Explicit JOIN syntax is more readable and maintainable

✅ Summary

Style

Syntax Example

✅ Implicit JOIN

FROM A, B WHERE A.id = B.a_id

✅ INNER JOIN

FROM A INNER JOIN B ON A.id = B.a_id

❌ No LEFT/RIGHT

Implicit join can’t do outer joins