Subqueries in MySQL 4.1?
If I do a query for:
select id from table1 where user="me"
I get a list of 5 items.
Now I want to exclude those 5 ids from another query, with something like this:
select content from sentences where id NOT IN ( (select id from table1 where user="me") )
But that gives me an error of "Subquery returns more than 1 row". Anyone have any suggestions to make this work?
u cannot use sub queries in mysql 4.1
u need to hava 5.0
u must maek `user` feild a uniqe feild, then u will only get only one row, in ur case u must be having more the one rows where u have `user` = ‘me’
References :
u cannot use sub queries in mysql 4.1
u need to hava 5.0
References :