I have a table 1, table2.
id, -- Primary Key
id, -- FK reference to table 1
Qid, -- PK
survey_id, -- FK reference to table 2
question -- has values like q1, q2, q3, ..
ans also I wants to store this values as columns like
Now survey_id has values like survey1,survey2, survey3, ...
Now I wants this values survey1, survey2, ... as a columns like
so My reports looks like as below
Id, fname, lname, birth_dt, status, survey1, survey2, survey3, ..., q1, q2, q3, ....
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!