nwhse cprod GetThisVal 1 "A" 1 1 "C" 3 2 "B" 22 3 "A" 111 3 "D" 222David, I tried the query below but it does not return the desired results above.
select test1.*, test3.GetThisVal ; > from test1 ; > inner join test2 ; > on test1.nwhse = test2.nwhse ; > inner join test3 ; > on test2.cwhse = test3.cwhse and test1.cprod = test3.cprod ; > into cursor theresult >>
>>close databases all >>set safety off >>set confirm off >>create table test1 (nwhse i, cprod c(1)) >>insert into test1 values (1,'A') >>insert into test1 values (1,'C') >>insert into test1 values (2,'B') >>insert into test1 values (2,'C') >>insert into test1 values (3,'B') >>insert into test1 values (3,'A') >>insert into test1 values (3,'D') >> >>create table test2 (nwhse i, cwhse c(2)) >>insert into test2 values (1,'W1') >>insert into test2 values (2,'W2') >>insert into test2 values (3,'W3') >> >>create table test3 (cwhse c(2), cprod c(1), getthisval i) >>insert into test3 values ('W1','A',1) >>insert into test3 values ('W1','B',2) >>insert into test3 values ('W1','C',3) >>insert into test3 values ('W2','A',11) >>insert into test3 values ('W2','B',22) >>insert into test3 values ('W3','A',111) >>insert into test3 values ('W3','D',222) >>>>TIA