Hi, I have 3 files each having 2 cols e.g File1 empid deptid 1 100 2 200 3 200 4 100 5 300 File2 empid salary 1 10 2 20 3 30 4 40 5 50 6 60 File3 deptid deptname 100 A 200 B 300...

PLMS

• Mar 29th, 2013

Step 1: File1 - left outer Join {Key- empid} with -File2 Step 2: The above output flow should be sort{PBKS-if multifile} based on key empid Step 3: The step 2s o/p flow to be left outer joi...

Malini

• Apr 3rd, 2012

Code
  SELECT C.DEPTNAME,sum(B.SALARY) FROM FILE1 A ,FILE2 B ,FILE3 C
  WHERE A.EMPLID=B.EMPLID AND A.DEPTID=C.DEPTID
  GROUP BY C.DEPTNAME

Answer Question  Select Best Answer