Can I use the SQL Command exists in Access 2000?

K

Kim

I want to create a second table where only one unique entry is inserted into
the table, the problem is that the field I want to use is not the unique id
for the first table. So I'm wondering if there is a way to use exist or not
exist when doing queries in Access. Thanks
 
C

Chris2

Kim said:
I want to create a second table where only one unique entry is inserted into
the table, the problem is that the field I want to use is not the unique id
for the first table. So I'm wondering if there is a way to use exist or not
exist when doing queries in Access. Thanks
Click to expand...


Kim,

The EXISTS predicate works normally in JET SQL as far as I know.


Sincerely,

Chris O.
 
Top