I have two tables tblCalendar and tblRooms that both are joined together using a cartestion join. Next I have a vwRoomReservations that is LEFT joined to the cartesian tblRooms. One of the fields I'm using to join on, comes back as 'cal.cday invalid identifier'.
from tblCalendar cal, tblRooms R
left join vwRoomReservation RR on rr.roomid=r.id and cal.cday=trunc(rr.meetingStart)
If instead of using cal.cday, I use to_date('1/1/2005','mm/dd/yyyy') it works fine but of course it only returns one day.
Any hints or suggestions as how to do this differently?