I am having to learn PL/SQL on the job and a simple comparisson is kicking my butt.

Basically I want:

FROM member.member
INNER JOIN member.employment
ON member.member.SSN = member.employment.SSN

WHERE member.member.SSN
AND member.employment.SSN
LIKE SSN_MISC_WORKING.ssn

This is after an INNER JOIN on the two tables SSN.

I keep getting this error on the AND, error: ORA-00920: invalid relational operator

I have done some searching and such and have found no AND keyword mentioned in any examples. Any one have an idea and can tell me what it is I am missing? I am using TOAD on Oracle and have some experience with SQL and none with PL/SQL.

Thanks