Matching multiple information and bring the result

[Ibrarbutt]

Table 1

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]

Booked By[/TD]
[TD]Hotel Name[/TD]
[TD]Room Type[/TD]
[TD]No of Room[/TD]
[TD]Amount<strike></strike>[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Royal Hotel[/TD]
[TD]Single Room[/TD]
[TD]3[/TD]
[TD]1400[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Royal Hotel[/TD]
[TD]Twin Room[/TD]
[TD]2[/TD]
[TD]1600[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Mid Night Hotel[/TD]
[TD]Single Room[/TD]
[TD]4[/TD]
[TD]1200[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD]Royal Hotl[/TD]
[TD]Single Room<strike></strike>[/TD]
[TD]4[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]ZYX[/TD]
[TD]3 star Hotel[/TD]
[TD]Twin Room[/TD]
[TD]1[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]below 1000 records
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

















Result (1) Required
Table 2

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]
Hotel Name[/TD]
[TD]Single Room[/TD]
[TD]Twin Room[/TD]
[TD]Amounts[/TD]
[/TR]
[TR]
[TD]Royal Hotel[/TD]
[TD]Total of above[/TD]
[TD]Total of above[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mid night Hotel[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3 Star Hotel[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]may be 10 type of hotel
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]











Result (2) Required

i have table with the list of booked by, i need to match with above table and bring below result.
Table 3

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]
Booked By[/TD]
[TD]Single Room[/TD]
[TD]Twin Room[/TD]
[TD]Amounts[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Match with booking with table 1 and bring results as total[/TD]
[TD]Total of above[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ZYX[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]