MySQL Forums
Forum List  »  MySQL Query Browser

SQL Join
Posted by: shrawan sahu
Date: December 16, 2012 02:31PM

Hi,

I need help to to collect data from feedback tables.

I have tables like

1. tbl_parent_child_details

fld_parent_id fld_parent_name fld_child_name fld_class fld_section
1 Tom Ray 8 A
2 Dev angelina 12 B

2. tbl_feedback_children

fld_parent_id fld_quetion_id fld_ans
1 1 1
1 2 3
1 3 2
2 1 4
2 2 5
2 3 2

2. tbl_feedback_admini

fld_parent_id fld_quetion_id fld_ans
1 1 1
1 2 3
1 3 2
2 1 4
2 2 5
2 3 2
__________________________________________________

Now my requirement is I want data of every parent in one row like:

Parent child q1 q2 q3 q4 q5 q6
tom ray 1 3 2 1 3 2
dev angelina 4 5 2 4 5 2

Any help is highly appreciated.

Thanks,
Shrawan

Options: ReplyQuote


Subject
Written By
Posted
SQL Join
December 16, 2012 02:31PM
January 11, 2013 10:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.