>>>
>>>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.
I reread your message and then my question and now I am clear.
Thank you for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
