merging two database
-
i have 3 tables 1 master 2 advance 3 loan here some employe taken only advance,some only loan ,some both and some not availed. i want to list like this those are availed. emp_code emp_name adv_amt, loan emp_code is id for all three files regards chandru
-
i have 3 tables 1 master 2 advance 3 loan here some employe taken only advance,some only loan ,some both and some not availed. i want to list like this those are availed. emp_code emp_name adv_amt, loan emp_code is id for all three files regards chandru
-
i have 3 tables 1 master 2 advance 3 loan here some employe taken only advance,some only loan ,some both and some not availed. i want to list like this those are availed. emp_code emp_name adv_amt, loan emp_code is id for all three files regards chandru
SELECT emp_code, emp_name, sum(adv_amt) as adv_amt, sum(load) AS loan FROM ( SELECT emp_code, emp_name, adv_amt, 0 AS loan FROM master m INNER JOIN advance a ON m.emp_code = a.emp_code UNION ALL SELECT emp_code, emp_name, 0 AS adv_amt, loan FROM master m INNER JOIN loan l ON m.emp_code = l.emp_code )a GROUP BY emp_code, emp_name
Regards KP
-
SELECT emp_code, emp_name, sum(adv_amt) as adv_amt, sum(load) AS loan FROM ( SELECT emp_code, emp_name, adv_amt, 0 AS loan FROM master m INNER JOIN advance a ON m.emp_code = a.emp_code UNION ALL SELECT emp_code, emp_name, 0 AS adv_amt, loan FROM master m INNER JOIN loan l ON m.emp_code = l.emp_code )a GROUP BY emp_code, emp_name
Regards KP
-
SELECT MASTER.EMP_CODE,MASTER.EMP_NAME,ADVANCE.ADV_AMT, LOAN.LOAN FROM MASTER ,ADVANCE,LOAN WHERE MASTER.EMP_CODE=ADVANCE.EMP_CODE AND MASTER.EMP_CODE=LOAN.EMP_CODE AND LOAN.AVAILED='Y'
vivek