Fwd: where fieldA not equals fieldB

[Tim Davis]

Hi,

How do I structure a where sql condition to find where field a do not 
equal field b? I cannot get it to work at all.

Examples:

... WHERE t1.fieldA <> t2.fieldB and t1.fieldC = t2.fieldD ...
(this one claims an error in the expression)

or
... WHERE NOT t1.fieldA = t2.fieldB and t1.fieldC = t2.fieldD ...
(this example ignores the "NOT" condition)

Thanks,
Tim Davis

V4RB, Vserver (version 1)