I don't know if your desire to use the subquery form is academic or
performance driven. If I were having this much trouble getting a subquery
to work, I would refactor my queries using JOIN statements.
http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html
(your query #1 below)This query w
Hello, Lana.
Both queries works fine in 4.1.7 version. There were a lot of bugs in
earlier versions of MySQL with subqueries. I think you should upgrade to the
latest release.
Did you use $sql=".." in mysql client program? That won't work.
Try just
SELECT * from user_info WHERE (login_name