First table EMPID CODEID amount 0157 C 0 0157 F 0 0157 L 0 0157 M 0 0157 T 0 0737 C 0 0737 F 0 0737 L 0 0737 M 0 0737 T 0
second table EMPID CODEID TOTAL_PAID_AMT 0157 T 4174.10 0737 C 5565.93
SELECT f.EMPID, f.CODEID, ISNULL(s.TOTAL_PAID_AMT, 0) FROM FirstTable f LEFT JOIN SecondTable s ON f.EMPID = s.EMPID AND f.CODEID = s.CODEID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)