Is there an "In" expression?

BerkshireGuy

Hello,

I was looking at a Access query and noticed in the criteria it stated:

In ('001','002')

Can someone please explain what the In is? How does it different from
Or?

Thank you,

Brian

Nov 13 '05 #1

MGFoster

BerkshireGuy wrote:

Hello,

I was looking at a Access query and noticed in the criteria it stated:

In ('001','002')

Can someone please explain what the In is? How does it different from
Or?

It would be the same as:

ID = '001' or ID = '002'

It's just an easier way of doing multiple ORs.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 13 '05 #2

Tim Marshall

BerkshireGuy wrote:

In ('001','002')

Can someone please explain what the In is? How does it different from
Or?

Same as using or.

I don't know about Jet, but in Oracle, the SQL performance tuning texts
I have indicate it's a preferred syntax to using "or".

I also find in Jet or Oracle, it makes it easier for me, anyway, to
write SQL via VBA code.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

Nov 13 '05 #3

DFS

MGFoster wrote:

BerkshireGuy wrote:

Hello,

I was looking at a Access query and noticed in the criteria it
stated:

In ('001','002')

Can someone please explain what the In is? How does it different
from Or?

It would be the same as:

ID = '001' or ID = '002'

It's just an easier way of doing multiple ORs.

It has additional functionality that can be handy: when used within the
PIVOT clause of a crosstab query, it will restrict the query output to and
force the output of only those columns listed in the "In ('val1',
'val2',...)" statement.

Nov 13 '05 #4

Trevor Best

Tim Marshall wrote:

BerkshireGuy wrote:

In ('001','002')

Can someone please explain what the In is? How does it different from
Or?

Same as using or.

I don't know about Jet, but in Oracle, the SQL performance tuning texts
I have indicate it's a preferred syntax to using "or".

ISTR this was true in Access as well, dunno about now they keep changing
things :-)

--
This sig left intentionally blank

Nov 13 '05 #5