Hagen Schl�mer wrote: > "Olivier Fournier" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > news:[EMAIL PROTECTED] > > hello, > > > > I 've 3 tables > > > > create domain dom_cod_X char(1) not null > > // > > create domain dom_cod_2X char(2) not null > > // > > create domain dom_cod_3X char(3) not null > > // > > create domain dom_cod_4X char(4) not null > > // > > create domain dom_lib varchar(80) > > // > > create domain dom_mille fixed(4) > > // > > create domain dom_numero fixed(10) > > // > > > > create table coop > > ( code dom_cod_X primary key, > > raisoc dom_lib > > ) > > // > > create table centre > > ( coop dom_cod_X , > > code dom_cod_4X primary key, > > raisoc dom_lib , > > foreign key ( coop ) references coop on > delete restrict > > ) > > // > > create table camion > > ( numcam dom_numero primary key, > > centre dom_cod_4X, > > datcam timestamp default timestamp, > > cloture boolean default false, > > foreign key ( centre ) references > centre on delete > > restrict > > ) > > // > > > > 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 parenthesis 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 Best regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
