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
http://i46.tinypic.com/2di24k6.jpg

Can someone please help me.. I need it for tomorrow.

can someone tell me if it's possible??