Ad Code

Difference in Inner join and Left Outer Join.

State the basic difference between Inner join and Left Outer Join.

Inner Join : Only those rows from two tables are joined that have same value in the common attribute while In a left outer join, PROGRAM rows without a matching COURSE row appear in the result left table (i.e. the one that precedes in SQL statement) regardless of the existence of matching records in the right table.

Reactions

Post a Comment

0 Comments