>>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; >>>
SELECT * FROM ; (SELECT * FROM AA WHERE condition1; UNION ALL; SELECT * FROM AA WHERE condition2) SUBQUERY; WHERE condition3but you should watch out,