PostgreSQL with Ktor using Exposed || Part 08 - Joining Tables (INNER, LEFT, RIGHT, FULL, CROSS)
In this video, we dive deep into SQL JOINs using Kotlin + Exposed + PostgreSQL! You’ll learn how to perform various types of joins—INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, and CROSS JOIN—while using the Kotlin Exposed DSL.
We’ll cover:
✅ How to fetch only matching data with INNER JOIN
✅Including unmatched records with LEFT JOIN and RIGHT JOIN
✅Combining everything with FULL JOIN
✅Generating a Cartesian product with CROSS JOIN
🔗 Resources & Links
📌 Playlist: • PostgreSQL with Ktor using Exposed
📌 Ktor Fundamentals Playlist: • Ktor Server Fundamentals
📌 Ktor Project Generator: https://start.ktor.io
📌 Ktor Docs: https://ktor.io
📌 Exposed Docs: https://www.jetbrains.com/help/expose...
📌 Source Code:https://github.com/akashkamati/ktor-w...
#KotlinServerSide #ktor #postgres #exposed #sqljoins #columntransformation #postgresusingkotlin #hikaricp #dockerpostgresadminersetup #backenddevelopment #kotlininbackend #ktorserver #kotlin