Practice Queries

 1. How to join a table with like :  in one table we have data "CANADA" and in another table we have data "abc CANADA".  Now i want to apply a join using like clause.