Re: mySQL 4.1.3-beta subqueries(correction on table names)

2004-11-12 Thread SGreen
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

Re: mySQL 4.1.3-beta subqueries(correction on table names)

2004-11-12 Thread Gleb Paharenko
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