• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

IN syntax in access

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

thanks
0
anushahanna
Asked:
anushahanna
3 Solutions
 
rowansmithCommented:
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
 
peter57rCommented:
rowansmith,

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

...will definitely work in Access, assuming the 'a' fields are compatible.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now