looks like informix does not like the sql92 syntax for joining.
btw. p6spy is better suited to log the sqls.
jakob
[EMAIL PROTECTED] wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
