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