AccessFreak
Registered User.
- Local time
- Today, 04:07
- Joined
- Feb 19, 2009
- Messages
- 69
I need to do have a select query for the following information:
reservationnr, customerID, firstname(customer), lastname(customer), Total accommodationcosts and Total travelcosts.
In table Season there is an attribute called Holiday. If that attribute is NULL, that period is in lowseason. If this attribute is NOT NULL, the period is in higseason.
This is my pdm
Can someone please help me.. I need it for tomorrow.
reservationnr, customerID, firstname(customer), lastname(customer), Total accommodationcosts and Total travelcosts.
In table Season there is an attribute called Holiday. If that attribute is NULL, that period is in lowseason. If this attribute is NOT NULL, the period is in higseason.
This is my pdm
Can someone please help me.. I need it for tomorrow.
Last edited:
