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
Hello,
Since I had a problem with except operator and subqueries, I investigated a
topic on mysql version capability. I tried a few examples which were offered
on this mailing list, all of them gave me a syntax error, so I've read a
manual and tried some examples from it. However, things that m
Hello,
Since I had a problem with except operator and subqueries, I investigated a
topic on mysql version capability. I tried a few examples which were offered
on this mailing list, all of them gave me a syntax error, so I've read a
manual and tried some examples from it. However, things that m
