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