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