If your default is '0', I think, the new query should work.
Thanks
Javier
- Original Message -
From: Donna Robinson <[EMAIL PROTECTED]>
To: Javier <[EMAIL PROTECTED]>
Sent: Monday, April 29, 2002 7:14 PM
Subject: Re: Cross querying databases (again)
> Hi,
Hi.
Run EXPLAIN for both queries and see if it explains the difference (my
first guess is be that the indexes support the one query, but not the
other).
Also, what does "never finishes" mean? Please list the processlist
(using SHOW or mysqladmin) and have a look at the state of the query.
Bye,
