DAN2011
asked on
How to create a proper Nested select statement in mysql
I am getting the error message "subquery returns more than one row" with the code below? I am trying to select only those records from the table shosondemand who's id is in the tmp_shoe_id table. Whats wrong with the code?
select distinct * from shosondemand where id = (select * from tmp_shoe_id);
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.