Re: select all vaues, including those not in row

[Peter Brawley]

You want rows where x=100 or x<>200? That'd be ...

select x from tbl where x=100 or x<>200;

or

select case when x=100 then x when x<>200 then null end as x from t;

Otherwise I'm unclear on the requirement, please elaborate.