>>>
>>>SELECT ROOM1 ROOM,RES_DATE,RES_TIME;
>>> FROM Table WHERE condition1;
>>>UNION;
>>>SELECT ROOM2,RES_DATE,RES_TIME;
>>>FROM Table WHERE condition2;
>>>
>>
>
>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 am a little confused. Please clarify something. I understand what you said about ORDER BY. But regarding your second sentence, are you saying that I would need to have another SQL Select on the resulting cursor and that would be the only way to "filter" the resulting cursor?
"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
