#1242 - Subquery returns more than 1 row

Question

2.50/5 (2 votes)

See more:

SQL

SELECT answer FROM answer WHERE q_id=(SELECT q_id FROM question WHERE dept="Maths")

Posted 28-Sep-12 7:37am

Updated 28-Sep-12 7:41am

v2

Comments

Richard C Bishop 28-Sep-12 13:42pm

And your question is....?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RaisKazi · Accepted Answer · 2012-09-28T07:42:00

Try by changing it to as below.

SQL

SELECT answer FROM answer WHERE q_id in (SELECT q_id FROM question WHERE dept="Maths")

Posted 28-Sep-12 7:42am

Comments

YoGiV 28-Sep-12 13:46pm

Thank this query is working.

RaisKazi 28-Sep-12 13:48pm

Glad to know that, :) Cheers - Rais

YoGiV 28-Sep-12 14:00pm

Can you help me in php code.

RaisKazi 28-Sep-12 14:02pm

Haven't worked on PHP, but you may post it as a new question, so that it may be answered by someone. Cheers

Maciej Los 28-Sep-12 15:42pm

Good work, my 5!

RaisKazi 28-Sep-12 15:46pm

Thank you Maciej.