Proposed solution, Oracle

Language: Layout:

drop table table1 
\\
drop table table2
\\

create table table1 (
  EMPLID number(10),
  XX_EMPLID varchar2(10),
  GTN   number(10),
  DEDCD  varchar2(10),
  EFFDT  date
)
\\
 
create table table2 (
  EMPLID number(10),
  DEDCD  varchar2(10),
  EFFDT  date
)
\\

insert into table1
(  EMPLID, XX_EMPLID, GTN ,  DEDCD,   EFFDT)
values (    1,     'A1' ,       102,   'XXYY' ,    to_date('2016-10-02','YYYY-MM-DD'))
\\
     
insert into table1 (  EMPLID, XX_EMPLID, GTN ,  DEDCD,   EFFDT)
 values ( 1,  'A1' ,       103,   'XXYZ' ,    to_date('2016-10-02','YYYY-MM-DD'))
\\

insert into table2 (EMPLID , DEDCD,    EFFDT)
 values (1,      'XXYA',   to_date('2016-10-02','YYYY-MM-DD'))
\\

insert into table2 (EMPLID , DEDCD,    EFFDT)
 values (1,      'XXYZ',   to_date('2016-10-02','YYYY-MM-DD'))
\\

SELECT a.EMPLID,a.DEDCD, to_char(a.EFFDT,'YYYY-MM-DD') EFFDT, b.DEDCD as DEDCD2,GTN 
   FROM 
   (
   select  EFFDT,GTN,EMPLID,DEDCD,
        row_number() over (partition by EMPLID order by DEDCD) rn
 from table1 ) A
    LEFT OUTER JOIN 
    (
   select  EFFDT,EMPLID,DEDCD,
        row_number() over (partition by EMPLID order by DEDCD) rn
 from table2       
    ) B
 ON ( A.EMPLID=B.EMPLID AND A.EFFDT=B.EFFDT AND a.rn=b.rn)
\\


absolute service time: 0,94 sec