Is there still an AND Keyword in PL/SQL?
I am having to learn PL/SQL on the job and a simple comparisson is kicking my butt.
Basically I want:
INNER JOIN member.employment
ON member.member.SSN = member.employment.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.