Retrieving information-unique data comparing 2 tables

[#1]

Hi,

Could anybody assist wtih this issue I have ?

How can I retrieve unique information from 2 resident tables. I only want what is still unique do table 2

Table 1

Column 1  | Column 2 | Column3

20130601 |    'Jam'      | Serial N. 2233

20130610 |    'Milk'      | Serial N. 2234

Table 2

Column 1  | Column 2 |

2233          | 'Produce' |

2234          | 'Produce' |

2235          | 'Produce' |

2236          | 'Produce' |

What I want is to retrieve 2235 and 2236 from Table 2. Thanks in advance.

Rui

[#2]

hi,

use exists function.

syntax:

Load * [source] where not exists (<current table field to check>,<already loaded field to check>);

Niranjan M.

[#3]

Niranjan,

So would this be something like:

load * resident Table2 where not exists (Table.Column2, Table1.Column3);?

[#4]

Hi thanks for your reply.

Ok,

I used 2235 and 2236 as example. There are plenty ID that require selection.

[#5]

Attached the QVW which will get the unique records from 2 tables.

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#7]

Hi Guys,

Thanks a million!! That solves it.