Outer join query

[Gerald]

Hi,

I have two tables I want to query:

table ClassRegist: fields Employee, Class
table Reviews: fields Employee, Class

How do I query the two tables such that it returns ONLY the data in ClassRegist
that DOES NOT appear in Reviews?

I've tried doing Outer join but that also returns the Inner data.

Thanks in advance for the help.

[Eva]

Gerald,
May be you are looking for something like that:

**************************************
SELECT cr.EMPLOYEE
FROM ClassRegist cr
LEFT OUTER JOIN Reviews r
ON r.EMPLOYEE = cr.EMPLOYEE
WHERE cr.EMPLOYEE IS NULL

**************************************

"Gerald" <ggiam77@yahoo.com> wrote:
>
>Hi,
>
>I have two tables I want to query:
>
>table ClassRegist: fields Employee, Class
>table Reviews: fields Employee, Class
>
>How do I query the two tables such that it returns ONLY the data in ClassRegist
>that DOES NOT appear in Reviews?
>
>I've tried doing Outer join but that also returns the Inner data.
>
>Thanks in advance for the help.
>
>

[Eva]

Sorry, it should read:

>**************************************
>SELECT cr.EMPLOYEE
>FROM ClassRegist cr
> LEFT OUTER JOIN Reviews r
> ON r.EMPLOYEE = cr.EMPLOYEE
>WHERE r.EMPLOYEE IS NULL
>
>**************************************