Frage im Vorstellungsgespräch bei Deltek
Difference between left outer and inner join in SQL.
Antwort im Vorstellungsgespräch
Anonym
17. Sep. 2015
LEFT OUTER JOIN returns all the rows from the first table, even if there are no matches in the second table. RIGHTOUTER JOIN returns all the rows from the second table, even if there are no matches in the first table. INNER JOINrequires there is at least a match in comparing the two tables.
1