Rafal,
Monday, July 08, 2002, 4:44:32 PM, you wrote:
RJ> mysql version 3.23.50
RJ> Field kwData_wydania is of type date. As you can see, dates are different that
RJ> expected. Is this a bug?
Nope. Check the manual:
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.
Re-write you query :
SELECT ksiazka_wyd.kwId,kwData_wydania
FROM ksiazka_wyd
LEFT JOIN serie ON ksiazka_wyd.srId=serie.srId
WHERE kwData_Wydania
BETWEEN '2002-07-01' AND '2002-07-31'
LIMIT 5;
RJ> Select ksiazka_wyd.kwId,kwData_wydania
RJ> -> from ksiazka_wyd
RJ> -> LEFT JOIN serie ON ksiazka_wyd.srId=serie.srId and
RJ> -> kwData_Wydania
RJ> -> between '2002-07-01' and '2002-07-31'
RJ> -> limit 5;
--
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
