Click here to Skip to main content
12,072,536 members (69,411 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL
SELECT answer FROM answer WHERE q_id=(SELECT q_id FROM question WHERE dept="Maths")
Posted 28-Sep-12 8:37am
YoGiV262
Edited 28-Sep-12 8:41am
RaisKazi34.1K
v2
Comments
richcb 28-Sep-12 13:42pm
   
And your question is....?

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Try by changing it to as below.
SELECT answer FROM answer WHERE q_id in (SELECT q_id FROM question WHERE dept="Maths")
  Permalink  
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.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160208.1 | Last Updated 28 Sep 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100