IN syntax in access

is t-sql's IN, NOT IN syntax work in access sql the same way?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
rowansmithConnect With a Mentor Commented:
Yes.  It is exactly the same.

See : http://msdn.microsoft.com/en-us/library/bb208859(v=office.12).aspx

-Rowan
0
 
rowansmithCommented:
However I should clarify that you can not use "in" with another select statement in access (as you can with T-SQL).

eg:  select a from tabX where a in (select a from tabY)

Will not work in access.
0
 
peter57rConnect With a Mentor Commented:
rowansmith,

select a from tabX where a in (select a from tabY)

...will definitely work in Access, assuming the 'a' fields are compatible.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Ditto what Peter said; I use the IN keyword frequently in Access with a sub-select.
0
 
rowansmithCommented:
Agreed. My mistake.
0
 
anushahannaAuthor Commented:
Thank you experts.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.