Mad Mel
I tried both
select
g.g_name,
datediff(d, r.res_checkin_date, r.res_checkout_date)*p.rate+i.inv_amount
from reservation as r
inner join price_plan as p
on r.price_plan = p.price_plan
inner join invoice as i
on r.confirm_no = i.confirm_no
inner join guest_reservation as g
on r.confirm_no = g.confirm_no
and
SELECT guest_reservation.g_name, (DATEDIFF(d, reservation.res_checkout_date, reservation.res_checkin_date) * price_plan.rate ) + invoice.inv_amount
FROM guest_reservation JOIN invoice ON guest_reservation.confirm_no = invoice.confirm_no
JOIN reservation ON guest_reservation.confirm_no = reservation.confirm_no
JOIN price_plan ON reservation.price_plan = price_plan.price_plan
Both of those queries gave me the same result:
I had NO errors however NO results returned only a g_name column and a "no column name" column and no results in them?
|