Hello, If it's a documented feature which I've missed - please excuse, but after upgrading from 4.0.2 to 4.0.7 the following sql statement started to behave differently then before:
select Sections.ReportName, Creatives.Name, from HourlyStats natural left join Sections left join Creatives on HourlyStats.CreativeID=Creatives.CreativeID where HourlyStats.CreativeID=185; Instead of returning only rows existing in BOTH tables, it now returns rows which exist at least in one table. To make this statement working correctly, the brackets have to be inserted: select Sections.ReportName, Creatives.Name, from (HourlyStats natural left join Sections) left join Creatives on HourlyStats.CreativeID=Creatives.CreativeID where HourlyStats.CreativeID=185; Are the brackets here required by sql standart and was it a bug in the 4.0.2 which permitted working correctly even without them? Or how can it be explained? Thanks ---- Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) --------------------------------------------------------------------- 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