Re: [SQL] Breaking up a query

2006-08-15 Thread Scott Marlowe
On Thu, 2006-08-10 at 17:53, Saad Anis wrote: > Hi Guys, > > A fellow at work has written the SQL below to retrieve some data from > multiple tables. Obviously it is inefficient and unnecessarily complex, and > I am trying to break it into 2 or more queries so as to enhance performance. Nope, tha

Re: [SQL] Breaking up a query

2006-08-13 Thread Andrew Sullivan
On Thu, Aug 10, 2006 at 06:53:33PM -0400, Saad Anis wrote: > Hi Guys, > > A fellow at work has written the SQL below to retrieve some data from > multiple tables. Obviously it is inefficient and unnecessarily complex, and Why is that obvious? Why do you think that joining in your application is

Re: [SQL] Breaking up a query

2006-08-12 Thread Aaron Bono
On 8/10/06, Saad Anis <[EMAIL PROTECTED]> wrote: Hi Guys,A fellow at work has written the SQL below to retrieve some data frommultiple tables. Obviously it is inefficient and unnecessarily complex, andI am trying to break it into 2 or more queries so as to enhance performance. Can you please help m

[SQL] Breaking up a query

2006-08-10 Thread Saad Anis
Hi Guys, A fellow at work has written the SQL below to retrieve some data from multiple tables. Obviously it is inefficient and unnecessarily complex, and I am trying to break it into 2 or more queries so as to enhance performance. Can you please help me do so? I would appreciate any help you can