1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
Create table tbl_Position (cFamille char(4), cCat char(4), cSubCat char(4),cRef char(4), fData_1 Float, vcData_2 varchar(20) )
/* Clef primaire Famille SubCat Float*/
Create table tbl_Description_Group (ID_cGroup char(12), vcData_2 varchar(30) )
/* Clef primaire Famille SubCat Float*/
insert into tbl_Position (cFamille , cCat , cSubCat,cRef , fData_1 , vcData_2)
values( 'fAAA' ,'cAAA', 'sAAA' ,'T1', 2.2 , 'AAAqsdfqsdf')
insert into tbl_Position (cFamille , cCat , cSubCat,cRef , fData_1 , vcData_2)
values( 'fBBB' ,'cBBB', 'sBBB' ,'T2', 3.2 , 'BBBqsdfqsdf')
insert into tbl_Position (cFamille , cCat , cSubCat,cRef , fData_1 , vcData_2)
values( 'fCCC' ,'cCCC', 'sCCC' ,'T3', 4.2 , 'CCCqsdfqsdf')
insert into tbl_Description_Group (ID_cGroup , vcData_2)
values( 'fAAA'+'cAAA'+ 'sAAA' , 'AAAqsdfqsdf')
insert into tbl_Description_Group (ID_cGroup , vcData_2)
values( 'fBBB'+'cBBB'+ 'sBBB' , 'BBBqsdfqsdf')
insert into tbl_Description_Group (ID_cGroup , vcData_2)
values( 'fCCC'+'cCCC'+ 'sCCC' , 'CCCqsdfqsdf')
/* */
select *
from tbl_Position Pos inner join tbl_Description_Group Desc_
on Pos.cFamille + Pos.cCat +Pos.cSubCat = Desc_.ID_cGroup |
Partager