On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
> He is doing an inner join, you are doing a left join, they (potentialy)
> do not produce the same results.
Hmm have to think about it... inner means fields where the right table has
a NULL value in the condition are left out, right?
> If you have 5 hour selects you are probably missing some vital indexes, or
> you are using a long of like '%blah' or "OR"
... or using 1.5GB big tables...
thanks,
-christian-
--
Christian Hammers WESTEND GmbH - Aachen und Dueren Tel 0241/701333-0
[EMAIL PROTECTED] Internet & Security for Professionals Fax 0241/911879
WESTEND ist CISCO Systems Partner - Premium Certified
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php