Re: one of values ...

On 03/10/16 09:43, Remigio wrote:
> Hi,
> on a SELECT statement I want to use three different instructions on WHERE clause:
> field A must be <> 5
> field B and /or field C must be <> 0
> How do I write the sql for this?
> thank you very much
>

you already have

select ...... WHERE (field_A != 5) AND (field_B !=0 OR field_c !=0)
> __
> Remigio
>

-- 
Karl Marx said religion is the opium of the people.
But Marxism is the crack cocaine.