Possible Bug???

[X Y]

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

__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster
http://search.yahoo.com