Basic filtering question

[raju_salmon]

Hi,

I am new to qv, can you please help me on this?

I have two tables.

Table A                                       

ID Product

1   A

2   B

3   C

4   D

5   E

6   F

7   G

8   H

9   I

10  J

Table B

ID Product

6   F

7   G

8   H

9   I

10  J

I want to remove the records in Table A those are available in Table B.

How can i achieve this? Exist or not exists function or any other one?

Thanks.

[sundarakumar]

Load table b first then load table a with a where condition like

where not exists(Product);

B:
Load *  from B;

A:

Load *  from A

where not exisits(Product);

-Sundar

[raju_salmon]

It is giving whole 10 records Bro since it is concatenating.

[Anonymous · Accepted solution]

use noconcatenateand drop table B or rename fields otherwise syntetic keys are build

A:

noconcatenate Load *  from A

where not exisits(Product);

[#5]

you can usu noconcatenate