1. i am having 2 table to comapre the data with patient1 and patient2
fields have excatly same in both table,suppose having multiple data like 10 rows in both table
we have to check for current month only .
if exactly same patient records present ,then upd_date of patient1 table upadate with current date.
Patient1table : patient_id firstname lastname upd_date
patient2table: patient_id firstname lastname upd_date