SELECT t1.srNo,t1.Data as OLDData,t2.Data as ChangeData FROM table1 AS t1 INNER JOIN table2 AS t2 ON t2.srno = t1.srno WHERE t1.date = YYYYMMDD or t2.date=YYYYMMDD.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)