Removing duplicate data from different tables

[Anonymous]

Hi guys.

I have two tables

Salesman 1

PIN

Sales_amount

‘Salesman1’ as Salesman

Salesman 2

PIN

Sales_amount

‘Salesman2’ as Salesman

There is a chance that someone might apply via more than one salesman. For example they go to Salesman2 to make their original application and then realise they have made a mistake and go to Salesman1 to apply again.

I’d like to identify anyone who appears in more than one table and remove them from the Salesman1 table. Can this be done?

[deepakqlikview_123]

Can you please expalin what u want exactly.

f u want to just calcu8lation use distinct clause

eg for counting distinct records count( distinct value).

Thanks

[anbu1984 · Accepted solution]

Salesman2:

Load PIN,Sales_amount,‘Salesman2’ as Salesman From Salesman2;

NoConcatenate

Salesman1:

Load PIN, Sales_amount, ‘Salesman1’ as Salesman From Salesman1 Where Not Exists(PIN);