Table 1
<tbody>
</tbody>
Result (1) Required
Table 2
<tbody>
</tbody>
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
<tbody>
</tbody>
Booked By | Hotel Name | Room Type | No of Room | Amount<strike></strike> |
ABC | Royal Hotel | Single Room | 3 | 1400 |
ABC | Royal Hotel | Twin Room | 2 | 1600 |
ABC | Mid Night Hotel | Single Room | 4 | 1200 |
XYZ | Royal Hotl | Single Room<strike></strike> | 4 | 100 |
ZYX | 3 star Hotel | Twin Room | 1 | 120 |
below 1000 records | ||||
<tbody>
</tbody>
Result (1) Required
Table 2
Hotel Name | Single Room | Twin Room | Amounts |
Royal Hotel | Total of above | Total of above | |
Mid night Hotel | |||
3 Star Hotel | |||
may be 10 type of hotel |
<tbody>
</tbody>
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
Booked By | Single Room | Twin Room | Amounts |
ABC | Match with booking with table 1 and bring results as total | Total of above | |
XYZ | |||
ZYX | |||
<tbody>
</tbody>