Re: Inner Join and Informix

2004-03-15 Thread Jakob Braeuchi
there somebody that is working with Informix and OJB ? thanks. - Mensaje Original - De: Jakob Braeuchi <[EMAIL PROTECTED]> Fecha: Miercoles, Marzo 10, 2004 7:29 pm Asunto: Re: Inner Join and Informix hi ? looks like informix does not like the sql92 syntax for joining. btw. p6spy is be

Re: Inner Join and Informix

2004-03-15 Thread [EMAIL PROTECTED]
So, OJB don't support Informix ? Is there any way that OJB builds SQL that Informix support ? Are there somebody that is working with Informix and OJB ? thanks. - Mensaje Original - De: Jakob Braeuchi <[EMAIL PROTECTED]> Fecha: Miercoles, Marzo 10, 2004 7:29 pm Asunto: Re:

Re: Inner Join and Informix

2004-03-10 Thread Jakob Braeuchi
hi ? 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

Inner Join and Informix

2004-03-10 Thread [EMAIL PROTECTED]
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 th