MySQL Forums
Forum List  »  Optimizer & Parser

Re: Multiple join and Where clause
Posted by: Björn Steinbrink
Date: November 22, 2006 04:20PM

According to your sample you don't want to filter which rows to retrieve, but which to join, so the checks for 'expected' and 'final' should be moved into the join condition. And following the first row in the example result set, you also want to move the date check into the join condition for table2.

I couldn't figure out what the last row in the example means (what kind of date is "1"?). Is that just a typo or does it have some special meaning?

Options: ReplyQuote


Subject
Views
Written By
Posted
42831
November 15, 2006 05:13AM
Re: Multiple join and Where clause
6890
November 22, 2006 04:20PM


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.