by shorti <lbryan21@[EMAIL PROTECTED]
>
Apr 22, 2008 at 11:21 AM
>
> Also, you might concider rewriting som of your "in predicates" as
> joins/exists queries
>
> HTH
> /Lennart- Hide quoted text -
>
The UNION ALL did work. I read some on it yesterday but I thought it
was used for something else. Are the JOIN and EXISTS more efficient
than using IN? I tried to do some simple JOINs instead but I could
not get it to work right. I am looking at EXISTS at the moment.
Thanks for your help.