List box

[selcukcadir]

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 ?

[sudeep_d · Accepted solution]

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;