I have a database containing multiple tables (Person, Parents, etc)
Person table has certain attributes particularly ssn, countryofbirth and currentcountry.
Parents table has ssn, and fathersbirthcountry
I'm trying to output the SSNs of all people who have the same countryofbirth as their fathersbirthcountry and also have same currentcountry as fathersbirthcountry.
SELECT Person.ssn
FROM Person, Parents
WHERE fathersbirthcountry = countryofbirth
AND currentcountry = fathersbirthcountry;
the above doesn't seem to be working, could anyone please help me out?