Frage im Vorstellungsgespräch bei Soros Fund Management

In SQL, what is the difference between an inner join and an outer join?

Antwort im Vorstellungsgespräch

Anonym

1. Jan. 2019

Inner Join - only shows common data from two or more tables, and removes duplicate. Outer Join - = returns unmatched rows from both tables