tsql - SQL Pivot and get column row data

Question

I have tables and data as below. Trying to get the Manufacturer and the questions they answered by joining and pivot but able to. Added the expected output at the end but no luck. Any suggestions are appreciated.

tblManufacturer

MFRID	MFRNum
1	3M
2	GM
3	HD
4	GL

question from:https://stackoverflow.com/questions/65893082/sql-pivot-and-get-column-row-data

Answer 1

You could try something like this

select m.*,
       max(case when q.MFRQTEXT='ENTER PRICE??' then qa.MFRANSWER else null end) [ENTER PRICE??],
       max(case when q.MFRQTEXT='WHAT IS TIME??' then qa.MFRANSWER else null end) [WHAT IS TIME??],
       max(case when q.MFRQTEXT='WHAT IS RANGE??' then qa.MFRANSWER else null end) [WHAT IS RANGE??]
from tblManufacturer m
     join tbMFRQuestionAnswers qa on m.MFRID=qa.MFRID
     join tblMFRQuestions q on qa.MFRQID=q.MFRQID
group by m.MFRID, m.MFRNum
order by m.MFRID, m.MFRNum;