[Solved] Oracle NOT pl/sql [closed]

Question

I think you want this:

select * from inside_sales where x = 'equipment'
union all
select * from outside_sales where x <> 'equipment';

Note: The second condition is slightly more complicated if x can be NULL.

Accepted Answer

I think you want this:

select * from inside_sales where x = 'equipment'
union all
select * from outside_sales where x <> 'equipment';

Note: The second condition is slightly more complicated if x can be NULL.