If you get an error than move ORDER clause after WHERE. The T-SQL is particular about the clauses order.

>Any idea why everything works fine until I add the WHERE clause?
>
>

>lcfilter = 'ABC123'
>SQLEXEC(lnConnhandle," select t22.field3, t23.field3, t1.field1, t1.field4 from table1 t1 ;
>   JOIN table2 t22 ON t22.field1 = 'FKEY1' and t22.field2 = t1.field2 ;
>   JOIN table2 t23 ON t23.field1 = 'FKEY2' and t23.field2 = t1.field3 ;
>   ORDER BY 3, 4 ;
>   WHERE t1.field1 = ?lcfilter",'sqlresults')
>