Displaying 1 result from an estimated 1 matches for "reserved_on".
Did you mean:
reserved_1
2006 Jun 01
2
Union all
...need to get data from both using a "union all". Let''s think on
a hotel where I need to "glue" data to take a snapshot from the
occupation like:
Room (number,date,ocupied_by)
1,''2006/06/01'',John
2,''2006/06/01'',Paul
Reserved (number,reserved_on,reserved_by,expire_on)
3,''2006/06/01'',George,''2006/06/02 14:00''
4,''2006/06/01'',Ringo ,''2006/06/02 14:00''
select number, date, ocupied_by
from room
where date=''2006/06/01''
union all
select number, reserved_on...