Harald,
Wednesday, July 03, 2002, 11:06:36 PM, you wrote:
HK> >Description:
HK> I use LEFT JOIN to join together two tables. And (for some 'complex'
HK> reason) I want to add additional conditions into the join_condition-part
HK> (and not in the WHERE part where it would belong to). But these additional
HK> conditions seem to be ignored just as if they weren't there. If I cut the
HK> 'ON'-part and move conditions to the 'WHERE' all goes the way it should.
HK> Changing the join method from LEFT JOIN to INNER JOIN does fix the problem
HK> - yes but alas I need a LEFT JOIN in this case.
HK> The manual says
HK> "The ON conditional is any conditional of the form that may be used in a
HK> WHERE clause."
HK> So it _should_ be allowed to do the things that I do...
The manual also says:
You should never have any conditions in the ON part that are
used to restrict which rows you have in the result set. If you
want to restrict which rows should be in the result, you have
to do this in the WHERE clause.
Clause ON determines join condition between tables. Matching is done according to
columns that are specified in ON clause.
'person.deleted=0' and 'room.deleted=0' conditions are not used for joining tables,
they are used to confine rows in the result set.
HK> Maybe this is all my fault - so please be patient. But in any case: Thank
HK> you very much for spending time with my problem!
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
