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
