[Opensource] implementing outer join in MultiDBObject?

[larry hamel]

do you mean "why outer joins are NOT ..."  ?

will this work for most databases? mysql syntax seems to require more than just those two words, I believe, typically needing an "ON" keyword to specify the (loosely) matching columns. the syntax is explained here:

http://www.mysql.com/doc/en/JOIN.html

larry

At 05:05 PM 2/20/2003, you wrote:
>Something I've been wondering for a while is why outer join's are implemented in MultiDBObject. The way I see it, it would be quite simple - just have a setter and then check for that, adding 'OUTER JOIN' ('left' and 'right' if you want to support that) to the where clause. Am I missing something or should I go for it? (the only thing I could think of is database incompatibilities, which seems unlikely)
> 
>thanks,
>mike
>