Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
use noconcatenateand drop table B or rename fields otherwise syntetic keys are build
A:
noconcatenate Load * from A
where not exisits(Product);
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
It is giving whole 10 records Bro since it is concatenating.
use noconcatenateand drop table B or rename fields otherwise syntetic keys are build
A:
noconcatenate Load * from A
where not exisits(Product);
you can usu noconcatenate