Hi

I am having trouble writing a query in iReport using  Firebird SQL

I can get the query to work in MS Access, but I’m not familiar with Firebird SQL, seems to be different .

The access version of my query that works is

SELECT CUSTOMFIELDVIEW.INFO AS OtherName, SO.NUM

FROM CUSTOMFIELDVIEW INNER JOIN (SO INNER JOIN CUSTOMER ON SO.CUSTOMERID = CUSTOMER.ID) ON CUSTOMFIELDVIEW.RECORDID = CUSTOMER.ID

WHERE (((SO.NUM)="763905") AND ((CUSTOMFIELDVIEW.CFID)=78));

The closest I got in iReport using the Firebird SQL is

(SELECT CUSTOMFIELDVIEW.INFO as OtherName

FROM CUSTOMFIELDVIEW INNER JOIN (SO INNER JOIN CUSTOMER ON SO.CUSTOMERID = CUSTOMER.ID) ON CUSTOMFIELDVIEW.RECORDID = CUSTOMER.ID

WHERE    (((CUSTOMFIELDVIEW.CFID)=78))  ),

But this version is missing calling the SO.NUM field and the WHERE (((SO.NUM)="763905")

If I add them to the query, iReport throws an error saying its invalid syntax

Any help appreciated

Thanks

Pat