Beniamin Joke (7/14/2013)
Hithe 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
I don't see a "gmso" column in table GLMSO??
your setup code
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day