MySQL SubQuery
MySQL SubQuery
I was trying to do a sub-query here but it wouldn't work (Syntax Error) in MySQL for some reason even though based on the SQL standards it should be ok.
[i:1268bfa39e][b:1268bfa39e]I found the reason this doesn't work. I am using MySQL 3.23 and I read on the MySQL web site that versions before 4.1 DO NOT SUPPORT SUB-QUERIES so it showed me how to rewrite the following as a LEFT join instead of a sub-query.
[/b:1268bfa39e][/i:1268bfa39e]
[quote:1268bfa39e]
SELECT field
FROM Table1
WHERE Table1.field1 = (SELECT field1 FROM Table2 WHERE field2 ='somevalue')[/quote:1268bfa39e]
The MySQL site led me to create this solution:
http://dev.mysql.com/doc/mysql/en/rewriting-subqueries.html
[quote:1268bfa39e] SELECT field
FROM Table1
LEFT JOIN Table2 ON Table1.field1=Table2.field1
WHERE Table2.field2= 'somevalue'[/quote:1268bfa39e]
Tags:
mysql, subquerymysql, subqueryi, query, wouldn, syntax, sql, ok, bfa, doesn, versions, queries, rewrite, select, somevalue, http, dev, en, rewriting, subqueries, html,