I have two tables, one with notes

```
id, note, client#, flag, employee#, date

```

The other with employees

```
id, employee#

```

I want to find all the notes that have a "N" flag, but DO NOT have a "Y" flag for the same date and client#, but only for the employees that are in the employee table.

For example I start with:

```
1  mynote   123   Y   abc   1/1/2011
2  mynote   123   N   abc   1/1/2011
3  mynote   124   N   abc   1/1/2011
4  mynote   124   N   ccc   1/1/2011

```

(in my employees table I have employee abc)

so I started with:

```
SELECT * from notes a inner join employees b on a.employee = b.employee WHERE a.flag = 'N'

```

That works, I get what looks like a resonable list of notes for only the employees that are currently in the employees table (for example only abc - records 2 and 3 above).

Now, I need to get back only record 3 since it is an "N" record and has no matching "Y" record for the same date and client#.

I just cant seem to get the extra part figured out to add it on.

Thanks.