>>
>>

>>SELECT ROOM1 ROOM,RES_DATE,RES_TIME;
>> FROM Table;
>>UNION;
>>SELECT ROOM2,RES_DATE,RES_TIME;
>> FROM Table WHERE NOT ROOM2==""
>>

>
>If I may ask you another question. For the above SQL Select, do you know if there is a way to have a separate WHERE clause for top SELECT and bottom SELECT of the UNION?

Yes

SELECT ROOM1 ROOM,RES_DATE,RES_TIME;
 FROM Table WHERE condition1;
UNION; && this is a distinct union ( like a UNION NEWS
SELECT ROOM2,RES_DATE,RES_TIME;
FROM Table WHERE condition2;