Re: Ramming two SQL queries together.....
From: Mr.Frog.to.you_at_googlemail.com <mr.frog.to.you_at_googlemail.com>
Date: Fri, 28 May 2010 00:18:16 -0700 (PDT)
Message-ID: <dc3288e9-3a3e-4771-b7e6-3dc2fc446e4c_at_z33g2000vbb.googlegroups.com>
Thankyou both gentlemen. I appreciate the feedback you have given me. I am not an Oracle expert so I was not sure what the best approach was. I will set both up and see which runs faster (I am guessing the inline due to the way correlated subqueries run).
Date: Fri, 28 May 2010 00:18:16 -0700 (PDT)
Message-ID: <dc3288e9-3a3e-4771-b7e6-3dc2fc446e4c_at_z33g2000vbb.googlegroups.com>
Thankyou both gentlemen. I appreciate the feedback you have given me. I am not an Oracle expert so I was not sure what the best approach was. I will set both up and see which runs faster (I am guessing the inline due to the way correlated subqueries run).
I thank you both very much.
Cheers
The Frog Received on Fri May 28 2010 - 02:18:16 CDT