Loading only those records from one table, which are not present in another table
I have two different tables say A and B, both are loaded . Both tables have similar fields but with different names. In table A, there is a field "Clients" and table B have a field "Customers". Now, I want to create another table C and load only those Clients from A, which are not present in a Customers field of B.
Table A Clients > John, Peter, Graham, James, Brook
Table B Customers > John, Brook
Table C should have following names Clients > Peter, Graham, James
Please also provide a link where I can look for such operations.