I am using the following command for a remote view.

create SQL VIEW myview REMOTE CONNECTION myconnection AS ;
SELECT *;
FROM database.table1 table1, ;
database.table2 table2 ;
WHERE table1.field1 = table2.field2

I would like to change the WHERE statement in :

WHERE table1.field1 = table2.field2 and ;

table1.field3 > m.avalue

m.avalue is a memory vaiable containing an integer.

This doesn't work .
If anybody has a solution, thanks in advance.

Sena