Viewing 7 posts - 1 through 7 (of 7 total)
sorry it's kmso the column and not gmso ,i am a little sleepy
July 14, 2013 at 1:53 pm
Hi
the expected result should be where the gmso colums is equal to 003 from GLMSO table and which have in table GLCTA the column KCTR equal to 01 and 02
July 14, 2013 at 1:40 pm
i want the result for which :
table GLMSO which has the
gmso colum 0003 and has both of bot
of KCTR's in GLCTA table
06 ...
July 14, 2013 at 5:30 am
sorry,
here
create table GLCTA
(
IDN char(4),
KARA char(2),
KCTR char(2),
DCAT varchar(50) not null
)
go
insert into GLCTA
select '0099','01','06','Eme3Prodcat2x'
union all
select '0099','01','07','Eme4Prod'
union all
select '0099','02','07','Eme4Prod'
July 14, 2013 at 12:39 am
Hello I've updated in my previous comment
July 13, 2013 at 2:30 pm
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...
July 13, 2013 at 2:22 pm
Hi Luis
The dld statements you can find in here
Thanks
July 13, 2013 at 1:53 pm
Viewing 7 posts - 1 through 7 (of 7 total)