What’s the difference between RIGHT, LEFT, OUTER, INNER, JOIN


The difference is the way the tables are joined if no common records are available. RIGHT – RIGHT JOIN is the opposite of LEFT JOIN and the same as RIGHT OUTER JOIN. Shows all records from the right table and only matching records from the left table. LEFT – LEFT JOIN shows all records from the left table does not matter if matching records in the right table exists or not. Also the...

About Author

Ian Carnaghan

I am a software developer and online educator who likes to keep up with all the latest in technology. I also manage cloud infrastructure, continuous monitoring, DevOps processes, security, and continuous integration and deployment.

Follow Me