Joining two tables with the same rows

[melo]

Hi! Can someone help me here? I just got this code from other topics and use it for my system but i have a problem

 

$idList = join (',', array_map('intval', array_keys($_POST['answers'])));		
$sql = "SELECT QuestionId, answer
FROM tblquestion_mc WHERE QuestionId IN ($idList";

 

what i am trying to do is to join my table: tblquestion_default to that code above but i don't know how to. 

 

My tables contain this:

 

table name: tblquestion_mc

QuestionId | Answer

 

table name" tblquestion_default

QuestionId | Answer

[rgopal101]

Plz Say me what you want  output of join two tables

[melo]

I need to get the answers from the two tables

[jcbones]

Try:

 

SELECT o.QuestionId, o.Answer AS Answer1, t.Answer AS Answer2 FROM tblquestion_mc AS o JOIN tblquestion_default AS t ON o.QuestionId = t.QuestionId WHERE o.QuestionId IN ($idList);

Edited March 18, 2013 by jcbones