List box

selcukcadir — Thu, 27 Sep 2012 10:36:38 GMT

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)

the contents of the list box can be as follows:

matdeg (listbox)

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 ?

Re: List box

sudeep_d — Thu, 27 Sep 2012 11:15:00 GMT

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;