Hi everyone,
I have two tables ( 900+ rows , 6 columns) I want to compare these two
tables and if table A has a record with a value in one of its specific
fields(exp "C") that matches with a record filed in table B remove its
record or at least eleminate it in the final report.
table A
A B C
bob fg 3
john ac 2
kim lk 1

table b
D B C
bob fg 1
edward ad 1
john ac 2

second record in table 1 and third record in table b are the same so I want
to delete it from final report
final report
H I G
bob ab 1
edward ad 1


--
Best regards,
Edward