Invesco interview question

Typical tech screen, c# syntax focus and sql. During the tech screen, what is a inner left/right join?

Interview Answer

Anonymous

6 Jan 2014

Inner: returns only rows that the two tables share. Right: returns matches from both and all from referenced table Left: opposite of right :)