[SQL] No Not join

[David Hood]

On the current VAPP the SQL statement

"SELECT table1.*, table2.* FROM table1, table2 WHERE 
((Table1.ID=Table2.ID2) and (Table1.Code=Table2.Code2)) and 
(Table1.Year=1900) and (Table2.Year2=1910)"

Runs fine giving expected results


"SELECT table1.*, table2.* FROM table1, table2 WHERE 
((table1.ID=Table2.ID2) and (Table1.Code!=Table2.Code2)) and 
(Table1.Year=1900) and (Table2.Year2=1910)"

Runs and ignores the (Table1.Code!=Table2.Code2) criteria when 
producing results


"SELECT table1.*, table2.* FROM table1, table2 WHERE 
((table1.ID=Table2.ID2) and (Table1.Code<>Table2.Code2)) and 
(Table1.Year=1900) and (Table2.Year2=1910)"

Fails with an aggregate function warning message

Since both the second and third query work fine in MYSQL I suspect it's 
a parser issue.

David