MySQL Forums
Forum List  »  Newbie

error code 1241, operand should contain 1 column(s)
Posted by: M IC
Date: January 13, 2013 03:15AM

Hi,

I'm getting "error code 1241, operand should contain 1 column(s)" errir with the sql code shown below, please help.

Use horsedb;
Select horse_id, Name from Horse
Where horse_id in (Select horse_id, count(*) as wins From entry where place <=3 having count(*) > 1)

Options: ReplyQuote


Subject
Written By
Posted
error code 1241, operand should contain 1 column(s)
January 13, 2013 03:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.