MySQL Forums
Forum List  »  Newbie

Re: Flaky MySQL?
Posted by: Roland Bouman
Date: July 28, 2005 03:18AM

Still looking...
Say, does it matter at all if you move the non-joining conditions from the on clause to the WHERE clause?

I mean things like :

INNER JOIn ....
ON cd.RIC = eq.RIC
..
..
WHERE ...
AND (
cd.Div_Feature NOT IN (10, 30, 33)
OR (cd.Div_Feature IN (10, 30, 33)
AND NOT EXISTS (
SELECT *
FROM corax_dividends cd2
WHERE cd.RIC = cd2.RIC
AND cd.Div_PILC = cd2.Div_PILC
AND cd.Div_Pay_Date = cd2.Div_Pay_Date
AND cd.Ex_Dividend_Date = cd2.Ex_Dividend_Date
AND cd2.Div_Feature IN (11, 31, 34)
)
)
)

in favour of:

INNER JOIN ...
ON cd.RIC = eq.RIC
AND (
cd.Div_Feature NOT IN (10, 30, 33)
OR (cd.Div_Feature IN (10, 30, 33)
AND NOT EXISTS (
SELECT *
FROM corax_dividends cd2
WHERE cd.RIC = cd2.RIC
AND cd.Div_PILC = cd2.Div_PILC
AND cd.Div_Pay_Date = cd2.Div_Pay_Date
AND cd.Ex_Dividend_Date = cd2.Ex_Dividend_Date
AND cd2.Div_Feature IN (11, 31, 34)
)
)
)
...
...
WHERE

Options: ReplyQuote


Subject
Written By
Posted
July 28, 2005 01:08AM
Re: Flaky MySQL?
July 28, 2005 03:18AM
July 28, 2005 03:27AM
July 28, 2005 09:06AM
July 28, 2005 01:39PM
August 01, 2005 03:25AM
August 01, 2005 03:42AM
August 13, 2005 04:02PM
August 13, 2005 05:08PM
August 13, 2005 05:10PM
August 15, 2005 11:50AM
August 16, 2005 02:07AM
August 16, 2005 02:33AM
August 17, 2005 05:56AM
August 17, 2005 12:16PM
August 19, 2005 01:44AM
August 19, 2005 01:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.