First page Back Continue Last page Image

Why Did I use a Right Outer Join

complement Table

Right Side

sfmembers Table

Left Side

SELECT * FROM complement RIGHT OUTER JOIN sfmembers ON complement.personid = sfmembers.memberID;

I want to see an entry for every record in the RIGHT table, even if it did not have a Match