Link to home
Start Free TrialLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

IN syntax in access

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

thanks
ASKER CERTIFIED SOLUTION
Avatar of rowansmith
rowansmith

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rowansmith
rowansmith

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.
SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Agreed. My mistake.
Avatar of anushahanna

ASKER

Thank you experts.