Bug #26441 Error in tutorial when stating the clause that matches records
Submitted: 16 Feb 2007 6:44 Modified: 16 Feb 2007 20:00
Reporter: Robert Ameeti Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
Assigned to: Paul DuBois CPU Architecture:Any

[16 Feb 2007 6:44] Robert Ameeti 
Description:
The text of the tutorial says: 

"The query uses WHERE clause to match up records in the two tables based on the name values."

But in fact the WHERE clause does nothing to match up records but rather to specify which event type to select. It is the FROM or the ON that specifies which records to match up.

How to repeat:
Read the tutorial. <http://dev.mysql.com/doc/refman/5.0/en/multiple-tables.html>
[16 Feb 2007 7:51] Valeriy Kravchuk 
Thank you for a reasonable documentation request.
[16 Feb 2007 20:00] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Thanks, you are correct. The original form of the query did
use WHERE to match the records. Apparently we forgot to
update the following text when we changed the query.