Can I use the SQL Command exists in Access 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top