Re: calculating prices

[Caroline C]

Hi Sorry one more question on this!
SELECT TRANSACTION_NO, RENT_DATE,DATE_RETURNED, due_date,CODE,OVERDUE_FEE,RENTAL_FEE
FROM RENTAL_DETAILS JOIN PRICE_CODE USING (CODE)
WHERE DATE_RETURNED IS BETWEEN ’2014-06-01’ AND ‘2014-06-30’
OR RENT_DATE IS BETWEEN ‘2014-06-01’ AND ‘2014-06-30’;

I have this code and it works until I add the OR in on line 5.I'm typing this into SQL from word so I know the issue isnt with the Microsft word inverted commas.

Also on this I need to calculate total revenue in the given period. It works that a customer pays the price in price code under rental_fee at rent_date. This is if library book is returned on time,If the library book is not retrned on time, he needs to pay no of nights overdue(due_date-date_returned)*value in overdue_fee.


Any suggestions on how to do this code? I'd say it would have to be an ad on to the code above.

Any help is appreciated!