List:General Discussion« Previous MessageNext Message »
From:Jennifer Date:February 18 2014 12:46am
Subject:Re: Narrowing a SELECT statement by multiple hits
View as plain text  
On Feb 17, 2014, at 12:36 PM, Roy Lyseng wrote:
> Try... `ip` IN (SELECT ip FROM temp_ip)

	Wow!  Only 1 second to return the results now!!  That's 15x faster!!!

> Each subquery needs to be a complete SELECT query.

	That's good to know.  I figured that since temp_ip referenced a complete SELECT statement
from before, that was good enough, but no.  There's always something new to learn!

Thanks again,
Jenni

	Superior Shelving Systems::::....
	The (Storage|Office|Display|Warehouse) Shelving Specialists
	Since 1984

Metro Shelving:
http://www.superiorshelving.com/mfg/metro/

Thread
Narrowing a SELECT statement by multiple hitsJennifer13 Feb 2014
  • Re: Narrowing a SELECT statement by multiple hitsLarry Martell13 Feb 2014
    • Re: Narrowing a SELECT statement by multiple hitsJennifer17 Feb 2014
      • Re: Narrowing a SELECT statement by multiple hitsRoy Lyseng17 Feb 2014
        • Re: Narrowing a SELECT statement by multiple hitsJennifer17 Feb 2014
          • Re: Narrowing a SELECT statement by multiple hitsRoy Lyseng17 Feb 2014
            • Re: Narrowing a SELECT statement by multiple hitsJennifer18 Feb 2014
          • Re: Narrowing a SELECT statement by multiple hitsshawn l.green17 Feb 2014