A Search and Join Condition

For each prime minister born in or after 1900, give his name,

birth year and party.

SELECT P.PM_NAME, BIRTH_YR, PARTY

FROM PRIME_MINISTER P, MINISTRY M

WHERE P.PM_NAME = M.PM_NAME AND BIRTH_YR >= 1900;

PM_NAME BIRTH_YR PARTY

Holt H E 1908 Liberal

McEwen J 1900 Country

Gorton J G 1911 Liberal