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, ....