Comparing 2 tables and "deleting" from one of them

[#1]

I have 2 tables. Table 1 contains 100 Store codes. Table 2 contains 1 Store code which is also in Table 1. I want to remove the store code from table 1 that exists in Table 2. I'm not sure of the syntax to do that. Can someone help?

[#2]

Hi,

Try and adapt this example:

----------------------------

Table1:

load RowNo() as CodeStore

AutoGenerate(100);

Table2:

load RowNo()+100 as StoreCode

AutoGenerate(99);

Concatenate

LOAD 2 as StoreCode

AutoGenerate(1);

Table3:

LOAD CodeStore as saveCode

Resident Table1

where not Exists(StoreCode,CodeStore);

Drop Table Table1;

RENAME Table Table3 to Table1;

RENAME Field saveCode to CodeStore;

-------------------------------

cordially,

Laurent

[#3]

i'm not sure but try outer join.

[#4]

Thank Laurent, I have been meaning to say thanks, it was very helpful!