ADO question - pass thru query for sql server using EXISTS

• Matt Miskinnis

  SSC-Addicted

  Points: 461

  More actions

  February 5, 2004 at 12:05 pm

  #65925

  I was first looking if access could run a stored procedure to SQL Server and get a result set back.  Instead I'm now basically looking if a record exists with a certain ID in a table (example:  select * from thistable where id = 'id_supllied_from_access').  I've done 'EXISTS' query's in sql analyzer and thats basically what I need - can I do the same through ADO in ACCESS?  Thanks for your help as I'm still getting familar with ADO.

• tymberwyld

  SSCertifiable

  Points: 7810

  More actions

  February 6, 2004 at 7:05 am

  #493057

  Select * From ThisTable Where ID IN(Select ID From ThatTable)

  OR

  Select * From ThisTable Where ID NOT IN(Select ID From ThatTable)