"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 > > Best regards > > Olivier Fournier
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
