Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Re: Query Help
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 3 Topic 8815 of 9349
Post > Topic >>

Re: Query Help

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.
 




 3 Posts in Topic:
Query Help
shorti <lbryan21@[EMAI  2008-04-22 08:39:46 
Re: Query Help
Lennart <Erik.Lennart.  2008-04-22 09:22:11 
Re: Query Help
shorti <lbryan21@[EMAI  2008-04-22 11:21:50 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 6 16:07:39 CDT 2008.