how to calculate a bill from several tables on mysql?
- by Audel
I'm using mysql to create an hotel booking system, but i am struggling a little bit to calculate the final bill.
I need a SELECT command to get data from several tables and make some calculations.
Basically I just need to get the 'night cost' from a table called 'room_types'. Then, use DATEDIFF function to get the difference of days between the…