>>>>
>>>>

>>>>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;
>>

>
>Thank you very much again, Fabio.

You're welcome.