Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
TABLE 1
matno (key) - matdeg - matkay
A1 B1 C1
A2 B2 C2
A3 B3 C3
A4 B4 C4
A5 B5 C5
TABLE 2
matno (key)
A1
A2
the contents of the list box can be as follows:
matdeg (listbox)
B1
B2
B3 (will not)
B4 (will not)
B5 (will not)
Do not get the records are not in the table 2 list box
how do I make ?
hi,
if u dnt want the rows of a1 and a2 then try this
test:
load
matno,
matdeg,
matkay
from table 1;
outer join
load
matno,
1 as flag
from table 2;
test2:
load
matno,
matdeg,
matkay
resident test
where flag<>1;
drop table test;
hi,
if u dnt want the rows of a1 and a2 then try this
test:
load
matno,
matdeg,
matkay
from table 1;
outer join
load
matno,
1 as flag
from table 2;
test2:
load
matno,
matdeg,
matkay
resident test
where flag<>1;
drop table test;