after selecting all of my columns i joined the tables as follows FROM EMPL B,
WHERE B.EMPL_ID = A.EMPL_ID(+)
AND C.EMPL_ID = A.EMPL_ID
AND C.BEN_PLAN_CD IN ('UHCALL','UHCBASIC')
AND B.EMPL_ID = D.EMPL_ID(+)
AND D.BEN_PLAN_CD IN('UHCALL','UHCBASIC')
and i am duplicating the employee file, for example;
v1.20abcdef 1800123456689 lastname1 firstname...
v1.20abcdef 00123456789 dep1lastname...
v1.20abcdef 1800123456789 lastname1 firstname...
v1.20abcdef 00123456789 dep2lastname...
If the employee has 3 dependents then its bringing back the employee file 3 times with its dependent underneath.
I just need the employee file once and dependents under.
Tables a Dependents
tables b Employee
tables c Dependent Elections
tables d Employee Elections