Hi,
This may be a really simple question but the answer is eluding me.
How do we create in Valentina's SQL a search which includes a lookup of
a field in one table does not equal in another table? Think of it like
an error checking query.
Example:
SELECT *
FROM t1, t2
WHERE t1.RecID = t2.t1ptr
AND NOT t1.field1 = t2.field1
Thanks,
Tim Davis
VSRV, V4RB