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
