SQLite Articles

Difference between Inner and Outer join in SQL

Himanshu shriv

Updated on 21-Jan-2020 2K+ Views

In Relational database tables are associated with each other and we used foreign key to maintain relationships between tables. We used join clause to retrieve data from associated tables. The join condition indicates how column in each table are matched against each other. There are two types of joins clause in SQL Inner join Outer joinOuter join is again divided into parts −LEFT OUTER JOIN - It will return all data of the left table and matched records in both table RIGHT OUTER JOIN - it will return all the data of the right table and matched records in ...