Hai i have two tables IN ACESS one rc table and dl table which contains of names,father name and address in both tables which contains of same name in different like in rc table name is shaik jeelan and in dl table name like s jeelan how can i match like this data of both tables
I AM TRYING USING QUEARY LIKE
SELECT RC.NAME,DL.NAME,DL.FATHERNAME,RC.FATHERNAME FROM RC,DL WHERE RC.NAME LIKE '*DL.NAME*' AND DL.FATHERNAME LIKE '*RC.FATHERNAME*', BUT NO RECORDS ARE GETTING