Hello

this was a fast way to share my query ,but i can paste here too.

create table GLCTR

(

IDN char(4),

KCTR char(2),

DCAT varchar(50) not null,

XMUL char(1) null,

FSCTR char(1) null,

FAP char(1) null

)

go

insert into GLCTR

select '0099','01','Settore','X','A','C' UNION ALL

select '0099','02','Servizio','X','A','C' UNION ALL

select '0099','03','EttoreCust1',null,'A','C' UNION ALL

select '0099','04','EttoreCust2','X','A','C' UNION ALL

select '0099','06','Eme3Prodcat2x','X','A','P' UNION ALL

select '0099','07','Eme4Prod',null,'A','P' UNION ALL

select '0099','08','sss','X','A','P' UNION ALL

select '0099','0C','AAA',null,'A','P'

go

create table GLCVA

(

IDN char(4),

KCVA char(4),

KCTR char(2),

DCVA varchar(50) not null,

FSCVA char(1) null

)

go

insert into GLCVA

select '0099','0001','01','Distribuzione','A' UNION ALL

select '0099','0002','01','Vendita','A' UNION ALL

select '0099','0003','02','Energia','A' UNION ALL

select '0099','0004','02','Acqua','A' UNION ALL

select '0099','0005','02','Gas','A' UNION ALL

select '0099','0007','07','aaa','A' UNION ALL

select '0099','0008','06','v2','A' UNION ALL

select '0099','0009','08','aaaa','A' UNION ALL

select '0099','000A','08','yyyyjjjjj','A' UNION ALL

select '0099','000B','04','aa','A' UNION ALL

select '0099','000C','04','bb','A' UNION ALL

select '0099','000D','06','v3','A' UNION ALL

select '0099','000E','06','v4','A'

go

create table GLTDM

(

IDN char(4),

KTDM char(2),

SIG varchar(10),

NOM varchar(50) not null,

DTDM varchar(30) null,

IMG image null

)

go

insert into GLTDM

select '0099','01','MAR1','Marchio1','Questoèilmarchio1', null

UNION ALL

select '0099','02','MAR2','Marchio2','Questoèilmarchio2', null

go

create table GLPSI

(

IDN char(4),

KPSI char(2),

NOM varchar(20),

DNAS varchar(10),

ORD char (1),

FAB char (1),

SIG char (7),

UPS char (7),

UPD varchar(12),

DESCR varchar(30),

COD char(3),

NTE varchar(40) null

)

go

insert into GLPSI

select '0099','01','Pacchetto1','00000000','0','A','EMEPS1','admin','201306121059','Ilpacchetto1', 'PS1','sdsdafdsa'

UNION ALL

select '0099','02','Pacchetto2','00000000','0','A','EMEPS2','admin','201306121059','Ilpacchetto2', 'PS2',null

go

create table GLMSO

(

IDN char(4),

KMSO char(4),

KMSOP char(6) null,

KARA char(2),

COD varchar(30) null,

NOM varchar (30) null,

DNAS char(8),

DINIV char(8),

DFINV char(8),

DFINA char(8),

FAB char(1),

UPS char(6),

UPD char(12),

KTDM char(2) not null

)

go

insert into GLMSO

select '0099','0003',null,'01','asdasd', 'asdasdas','00000000','00000000','99999999','99999999','A','admin','201307101544', '02'

UNION ALL

select '0099','0006',null,'02','ModuleSoftware2','NormeCondition2','00000000','00000000','99999999','99999999','A','admin','201307101214', '01'

UNION ALL

select '0099','0007',null,'01','Impersonaneeee','Pendice','00000000','00000000','99999999','99999999','A','admin','201307101230', '01'

UNION ALL

select '0099','0009',null,'02','Prodologia','34234234234','00000000','00000000','99999999','99999999','A','admin','201307101645', '02'

go

CREATE TABLE GLCMS

(IDN char(4),

KMSO char(4),

KCVA char(4),

FSCVA char(1)

)

go

INSERT INTO GLCMS

SELECT '0099', '0001', '0007', 'N' UNION ALL

SELECT '0099', '0001', '000D', 'A' UNION ALL

SELECT '0099', '0003', '0007', 'A' UNION ALL

SELECT '0099', '0003', '000D', 'A' UNION ALL

SELECT '0099', '0009', '0007', 'A' UNION ALL

SELECT '0099', '000A', '000D', 'A'

go

create table GLARA

(

IDN char(4),

KMSO char(4),

KARA char(2),

KPSI char(2)

)

go

insert into GLARA

select '0099','0003','01','01'

union all

select '0099','0003','02','01'

union all

select '0099','0006','01','02'

union all

select '0099','0007','02','01'

go

insert into GLCTA

select '0099','01','06','Eme3Prodcat2x'

union all

select '0099','01','07','Eme4Prod'

union all

select '0099','02','07','Eme4Prod'