问题描述
hi ..
我有3张桌子，如下面的波纹管所示
签到
ID RoomId ComingForm
1 1海得拉巴
2 2海得拉巴
3 3海得拉巴
4 3钦奈
6 2钦奈
7 1钦奈
8 3钦奈
房间
ID RoomName RoomClassId
1 101 2
2 102 2
3103 1
RoomClass
ID RoomClassName
1豪华
2普通
结果将是
CommingForm Luxury Narmal
海得拉巴2 1
钦奈2 2
这些是海得拉巴人等占领的豪华客房的数量.
请帮助我...
hi..
i have a 3 table like as shown in bellow
CheckIn
ID RoomId ComingForm
1 1 Hyderabad
2 2 Hyderabad
3 3 Hyderabad
4 3 Chennai
6 2 Chennai
7 1 Chennai
8 3 Chennai
Room
ID RoomName RoomClassId
1 101 2
2 102 2
3 103 1
RoomClass
ID RoomClassName
1 Luxury
2 Normal
Result will be
CommingForm Luxury Narmal
Hyderabad 2 1
Chennai 2 2
these are the count of luxury rooms occupied by the Hyderabad people etc..
plz help me...
推荐答案
这篇关于将行转换为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！