Re : Query hangs server

If I might add to this, if I run the queries seperately,
i.e Select distinct subscriberidx from
subscriber_emailcategories, and then

select
emailcategory from subscriber_emailcategories where
emailcategory in ('fh','si','wh','','','')

both queries work fine, only in the combination below do
they hang up the server??? Strange eh?

On Thu, 17 Mar 2005 13:19:10 +0200
"Greg Quinn" wrote:
> I have the following query
>
> Select distinct subscriberidx from
> subscriber_emailcategories where emailcategory in (select
> emailcategory from subscriber_emailcategories where
> emailcategory in ('fh','si','wh','','',''))
>
> Now on our one server, this query just hangs, on another
> server, with an identical database schema, it returns
> results instantly.
>
> Any ideas what I can start looking for?
____________________________________________________________ __
http://www.webmail.co.za the South African FREE email service

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org