sql bug?

[Ruslan Zasukhin]

On 5/11/04 2:46 AM, "Tim Davis" <timdavis at amug.org> wrote:

> Is this an error in the sql parser?
> 
> SELECT tblA.col1, tblB.col1
> FROM tblA, tblB
> WHERE tblA.recid = tblB.tblAptr
> and NOT tblA.col1 = tblB.col1
> 
> ... returns the same results as ...
> 
> SELECT tblA.col1, tblB.col1
> FROM tblA, tblB
> WHERE tblA.recid = tblB.tblAptr
> and tblA.col1 = tblB.col1
> 
> ... in other words the NOT is ignored.

Hi Tim,

Valentina 1.x do not support joins based on 2+ fields.


-- 
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
-------------------------------------------------------------