title: Opposite of inner join
body: <p>What will be the opposite of inner join? For a table table Person <code>(int PersonId, varchar PersoName, int AddrId)</code>, I want to know the rows in Person with bad <code>AddrId</code> which don't have a row in the <code>Address</code> table.</p>