Re: Nested query problem

2004-12-13 Thread Michael A Chase tech
On 12/13/2004 06:09 AM, Hardy Merrill said: I realize I'm splitting hairs here, and I'm no database expert, but I'm curious about your answer to this - wouldn't this be even slightly more efficient to write the WHERE clause conditions as most restricting first? In other words, SELECT

RE: Nested query problem

2004-12-13 Thread Hardy Merrill
Ronald, I realize I'm splitting hairs here, and I'm no database expert, but I'm curious about your answer to this - wouldn't this be even slightly more efficient to write the WHERE clause conditions as most restricting first? In other words, SELECT feature.id FROM feature,

Re: Nested query problem

2004-12-13 Thread Michael Peppler
On Mon, 2004-12-13 at 15:51, Chuck Fox wrote: Michael A Chase tech wrote on 12/13/2004, 9:24 AM: On 12/13/2004 06:09 AM, Hardy Merrill said: I realize I'm splitting hairs here, and I'm no database expert, but I'm curious about your answer to this - wouldn't this be even slightly

Re: Nested query problem

2004-12-13 Thread Chuck Fox
Michael A Chase tech wrote on 12/13/2004, 9:24 AM: On 12/13/2004 06:09 AM, Hardy Merrill said: I realize I'm splitting hairs here, and I'm no database expert, but I'm curious about your answer to this - wouldn't this be even slightly more efficient to write the WHERE clause

RE: Nested query problem

2004-12-10 Thread Ronald J Kimball
kaustubh shinde [mailto:[EMAIL PROTECTED] wrote: Hi, I am using MySQL 4.0.21. Following is the problem: I want to Select ID from Reporter where Attributes_ID = something and then use the resultant IDs to find Select ID from Feature where Reporter_ID = the IDs found in above statement.