Merge 2 select statements ?

Hi,

can anyone know how to merge two select statements into one

Example :

"select * from emp where location_id = 1"
other is
"select * from emp where location_id = 2"

Now how can i merge these two with a single select statement. its a simple example but i am using a tough one in reality.

Thanks

Jeff Received on Thu Nov 27 2003 - 14:17:26 CST