Hi, Text values go inside single quotes: WHERE mycol = ‘value’ With regards,
Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! 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)); 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
