Problem: Find records that match within two tables, TableA and TableB. Solution: Use a simple SELECT statement with a defined WHERE clause Lets assume that TableA and TableB have a field called “Phone” which contains the phone number of the clients and these numbers are obviously stored in a unique index. So what we are…

Problem: TableA contains a customer database TableB contains new names that you want to match against your customer database and remove all the names that are already customers. Solution: Use “LEFT JOIN” property of mysql to carry out the task. Lets assume that TableA and TableB have a field called “Phone” which contains the phone…