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, that's

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 me

[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