I wish to create a very simple query but cannot find the correct syntax mentioned in any documentation.
The WHERE clause needs to have the effect of ignoring certain records in a table ie
WHERE fieldvalue <> 12 AND fieldvalue <> 23 AND fieldvalue <> 37 etc etc for up to an unspecified number of values.
Is the above the correct syntax (very tedious to construct in expression builder or natively) or is there something more simple available such as
WHERE fieldvalue <> (12, 23, 37 ......)
Many thanks
The WHERE clause needs to have the effect of ignoring certain records in a table ie
WHERE fieldvalue <> 12 AND fieldvalue <> 23 AND fieldvalue <> 37 etc etc for up to an unspecified number of values.
Is the above the correct syntax (very tedious to construct in expression builder or natively) or is there something more simple available such as
WHERE fieldvalue <> (12, 23, 37 ......)
Many thanks
