Skip navigation links

MySQL Forums :: Newbie :: error code 1241, operand should contain 1 column(s)


Advanced Search

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: Reply•Quote


Subject Written By Posted
error code 1241, operand should contain 1 column(s) M IC 01/13/2013 03:15AM
Re: error code 1241, operand should contain 1 column(s) laptop alias 01/13/2013 10:46AM
Re: error code 1241, operand should contain 1 column(s) Peter Brawley 01/13/2013 10:49AM
Re: error code 1241, operand should contain 1 column(s) laptop alias 01/13/2013 11:30AM
Re: error code 1241, operand should contain 1 column(s) M IC 01/14/2013 05:26AM
Re: error code 1241, operand should contain 1 column(s) Peter Brawley 01/14/2013 10:26AM
Re: error code 1241, operand should contain 1 column(s) laptop alias 01/14/2013 10:41AM


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

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.