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,
u r my hero. I never, never
filter-fidder: sql, query
Hi,
Hope you don't mind me hassling you about this yet again.
... So you would need to run two queries, a LEFT JOIN and a
RIGHT JOIN (or a LEFT JOIN with tables swapped) to get all
results.
... ... which is what I did in the end.
except that on further checking
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,