how to join using two different select statements

• ramya.praba

  SSC Veteran

  Points: 285

  More actions

  January 27, 2011 at 5:52 am

  #230822

  select vtc.Question_ID,vtc.Answer,vq.Question_Name from Voc_Trans_Concern_Action_Details vtc,Voc_Mst_Feedback_Question vq where vq.Question_Id=vtc.Question_ID and vtc.Question_ID in (8,9,10,11,12)

  select vtc.Question_ID,vtc.Answer as actiontaken,vq.Question_Name from Voc_Trans_Concern_Action_Details vtc,Voc_Mst_Feedback_Question vq where vq.Question_Id=vtc.Question_ID and vtc.Question_ID in (13,14,15,16,17)

  The output is

  QuestionID Answer Questionname

  1 concern1 concern1

  2 concern2 concern2

  3 concern3 concern3

  QuestionID Actiontaken Questionname

  4 action1 action1

  5 action2 action2

  now i want output like

  Answer Actiontaken

  answer1 actiontaken1

  answer2 actiontaken2

  answer3

• Marco V

  SSCrazy

  Points: 2939

  More actions

  January 27, 2011 at 6:08 am

  #1279013

  http://www.sqlservercentral.com/articles/T-SQL/67202/