plus any common rows in B. select * from a LEFT OUTER JOIN b on a.a = b.b; select a.*

An inner join of A and B gives the result of A intersect B, i.e. the inner part of a venn diagram intersection. An outer join of A and B gives the results of A union B, i.e. the outer parts of a venn diagram union. Examples Suppose you have two Tables, with a single … Read more