MySQL Forums
Forum List  »  MySQL Query Browser

convert rows into column
Posted by: Indumathy Ramalingam
Date: July 28, 2011 05:39AM

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
Written By
Posted
convert rows into column
July 28, 2011 05: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.