A naukri.com initiative
Dev
1w
79
Image Credit: Dev
DAY5 OF PSQL Using Join Query
- INNER JOIN: Returns only the rows that have matching values in both tables.
- LEFT JOIN: Returns all rows from the left table and matching rows from the right table.
- RIGHT JOIN: Returns all rows from the right table and matching rows from the left table.
- FULL JOIN: Returns all rows when there is a match in either table.
Read Full Article
4 Likes
For uninterrupted reading, download the app