Olivier Fournier wrote: > I can't write 2 INNER JOIN in the same request? > > SELECT * FROM (CAMION INNER JOIN CENTRE ON CAMION.CENTRE = > CENTRE.CODE) > INNER JOIN COOP ON CENTRE.COOP = COOP.CODE
The bracket after the from is not valid. SAP DB only supports left deep joins so we decide to generally forbid brackets in the joined table clause also it only makes differences within outer joins. For more information about joins see: http://www.sapdb.org/htmhelp/ea/eba4f43e9211d3a98200a0c9449261/frameset.htm HTH. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
