Hi, I'm building an application with Informix 7.25 and RedHat 9.0 I have 2 tables : ventas and articulos, and I need make a ReportQuery that execute a similar SQL to "select sum(ventas) from ventas inner join articulos on ventas.idarticulo = articulos.id group by ventas.idarticulo".
I see in the log4j that the SQL is correct, but Informix fire a "Syntax Error" Exception. The correct syntax for Informix is similar to "select sum(ventas) from ventas, articulos where ventas.idarticulo = articulos.id" Any idea ? Thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
