Removing A Subset From A Main Table

I have 3 parcel tables. Table 1 contains the parcels of the whole county. Table 2 contains open space parcels and table 3 contains preserved farmlands. I would like to remove parcels in tables 2 and 3 from table 1. Tables 2 and 3 are subsets of table 1.

Basically I have these:

Table 1
PIN attribute1 attribute2 .....attribute6
1
2
3
.
.
.
52,000

Table 2
PIN
5
8
9
12
18
335
789
.
.
.
N

Table 3
PIN
41
51
66
3
78
903
1245
.
.
N

Note that tables 2 and 3 only contain PINs
Does anyone have a script for this problem?
I would appreciate your help on this. Thank you.


Jun