Possible Bug???

[Ruslan Zasukhin]

On 3/12/04 7:48 AM, "X Y" <xyzabc1010 at yahoo.com> wrote:

> Hi All,
> So I generated a query
> 
> SELECT * FROM TABLE1, TABLE2 WHERE
> TABLE2.field1 in ('a', 'b', 'c') AND TABLE1.id = 1 AND
> TABLE1.id2 = 2
> (note there is an obj ptr that reference table1 to
> table2)
> 
> This query gives me everything that is in the table1 x
> table2. However, switching the constraints around
> yields the correct results.
> 
> Has anyone notice this behavior before?

Once I have such problem.

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