MySQL Forums
Forum List  »  Performance

convert rows into column
Posted by: Indumathy Ramalingam
Date: July 28, 2011 04:19AM

hi

I have three tables holiday_mst, holiday_branches, and branch_mst

Branch_mst consist of following fields

branch_id branch_city
1 chennai
2 bangalore
3 calcutta

holiday_mst consist of following fields

holiday_id holidays
11 diwali
12 pongal
13 new year


holiday_branches consist of following fields

holiday_id branch_id status
11 1 1
11 2 1
11 3 1
12 1 1
12 2 0
12 3 0

now i want result in the following format

holidays chennai bangalore calcutta
diwali 1 1 1
Pongal 1 0 0

can anyone help me with this

Options: ReplyQuote


Subject
Views
Written By
Posted
convert rows into column
2981
July 28, 2011 04:19AM
1033
July 30, 2011 12:39AM


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.