Bug #1272 Missed comma in the manual (derived tables)
Submitted: 13 Sep 2003 12:25 Modified: 13 Sep 2003 12:42
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:4.1 OS:
Assigned to: CPU Architecture:Any
Triage: D4 (Minor)

[13 Sep 2003 12:25] [ name withheld ]
Description:
http://www.mysql.com/doc/en/Nutshell_4.1_features.html
and http://www.mysql.com/doc/en/News-4.1.x.html.

I am not sure, but i think you mistyped the following:

"SELECT t1.a FROM t1, (SELECT * FROM t2) t3 WHERE t1.a=t3.a;"

Forgot about the comma? Look:

"SELECT t1.a FROM t1, (SELECT * FROM t2), t3 WHERE t1.a=t3.a;"

How to repeat:
Go to http://www.mysql.com/doc/en/Nutshell_4.1_features.html
and http://www.mysql.com/doc/en/News-4.1.x.html and thing...

I am not sure, but i think you mistyped the following:

"SELECT t1.a FROM t1, (SELECT * FROM t2) t3 WHERE t1.a=t3.a;"

Forgot about the comma? Look:

"SELECT t1.a FROM t1, (SELECT * FROM t2), t3 WHERE t1.a=t3.a;"

Suggested fix:
Add the comma
[13 Sep 2003 12:42] Sergei Golubchik
no, comma is not missing. t3 is an alias for derived table.
It should be read as

SELECT t1.a FROM t1, (SELECT * FROM t2) AS t3 WHERE t1.a=t3.a;

but "AS" is optional, and omitted in this example