I am having trouble on how to display records who are not equal on b.sponsor_id=s.sponsor_id. Please help!
Your question sounds like you want to join the tables whose aliases are
s on some condition, and retain records which do not match. If you wanted to retain records from
b which do not match, then you can try using a
LEFT JOIN instead of an
SELECT b.* FROM tableB b LEFT JOIN tableS s ON b.sponsor_id = s.sponsor_id WHERE s.sponsor_id IS NULL