I have table A and table B loaded from QVD and I want just to stay with the values that just appear in A and not in B
May be this:
Where not Exists(KeyFields);
DROP Table TableB;
Thanks It work
Hi Sunny, thanks for the explanation.
I would like to know how should I do if I have the following fields:
So I want to exclude all ID# that has Doc#555.
And result shoud be a table with ID#2
Is there any way to achieve it?
You can try like this:
Right Join (Table)
Where Count = 0;
Count(If(Doc# = 555, Doc#)) as Count
Group By ID#;
Retrieving data ...