Morgan Stanley Interview Question

what is the diff b/t inner join and outer join?

Interview Answer

Anonymous

Jan 27, 2011

inner join allows you to retrieve data from multiple tables which match the join conditions. while outer join returns all rows from one table and only those rows from a secondary table where the joined conditin match

1