MySQL Forums
Forum List  »  Newbie

Re: Flaky MySQL?
Posted by: Roland Bouman
Date: July 28, 2005 01:39PM

David Wynter wrote:
> Knock yourself out. Thing is that it is not clear
> from the MySQL user manual that a sub query is a
> valid cond_expr in a OUTER LEFT JOIN. But the fact
> it works some of the time and not others dependent
> on the order in the statement then it is fair game

Ok, i agree, but when the condition does not relate both tables (i mean literally "apply a relational operator using an argument from the one and from the other table referenced in the JOIN clause"), i would not call it a 'join' condition, i would call it just: 'condition'. I've seen this 'condition' type of usage in some sections of the ANSI 9075:1999 spec, but i never write them in the ON, i write these in the WHERE.

> as far as I am concered. Also outer joining to the
> most recent record bar the current in a timeseries
> is a reasonably common thing to require, and I
> don't know any other way of doing it ;).

Sorry, you lost me there. What's that most recent record bar? please post a line of code to explain.

> You can move the restrictions in the ON part of
> the clause into the WHERE clause in response to
> your second to last post in this thread. But not
> logically for on OUTER JOIN as far as I can see.

Yeah, but, does the query work as desired when you do move them to the WHERE? Please tell, Im genuinly interested (although i do agree this usage should work consistently in all cases, so either always fail, or always succeed).

Options: ReplyQuote


Subject
Written By
Posted
July 28, 2005 01:08AM
July 28, 2005 03:18AM
July 28, 2005 03:27AM
July 28, 2005 09:06AM
Re: Flaky MySQL?
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.