> Perhaps this...? It would work, but depending how many rows are in the
> table, it could become incredibly slow.
The max rows in either table would be about 1000 or so, which isn't
too many. There also should be a hole lot of inserting going on.
> ALTER TABLE table1 ADD CHECK (extension NOT IN (SELECT extension FROM
> table2));
I guess this is the functionality i was looking for but was hoping
there would be a cleaner way to do it.
Anyways, thanks to everyone who replied. I'll look into each of the
proposed solutions to see what best suits my needs. If anyone has a
different solution i'd still like to hear it.
Jon