not equal related query

[Ruslan Zasukhin]

on 1/20/04 7:07 PM, Tim Davis at timdavis at amug.org wrote:

> 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

Hi Tim,

This one not works.
Works just fld = const

2 days ago about the same have ask Dave on this list.
Must works in 2.0


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------