>>
>>SELECT ROOM1 ROOM,RES_DATE,RES_TIME;
>> FROM Table WHERE condition1;
>>UNION;
>>SELECT ROOM2,RES_DATE,RES_TIME;
>>FROM Table WHERE condition2;
>>
>
>I am sorry for troubling you again. But I have one more question, please. You showed me how to have two WHERE, one for each SELECT, top and bottom. What if I wanted to have one WHERE that would apply to the resulting cursor, the one created with UNION?
The only SELECT caluse taht is applicable to the result of UNION is ORDER BY. You can run one more select of the cursor created by UNION with your WHERE conditions.
--sb--