Hi,

I have two table name is emp and pltdetail. i have extract all the data from emp and extract which is match in empcode from emp to pltdetail. I tried but i can't extract that data. Please tell me how to extract the data. see the below example.


Table names:

emp
empcode emploc
------- -------
AAAAAA newyork
BBBBBB DETROIT
CCCCCC washinton
DDDDDD michigo


Pltdetail
empcode pltcode
-------- --------
AAAAAA 87
BBBBBB 95



FOCUS code:


join empcode in emp to empcode in pltdetial as jo1

table file emp
print empcode emploc pltcode
end

Result below.

empcode emploc pltcode
------- ------- -------
AAAAAA newyork 87
BBBBBB DETROIT 95


But i need entire data from emp.

like below

empcode emploc pltcode
------- ------- -------
AAAAAA newyork 87
BBBBBB DETROIT 95
CCCCCC washinton
DDDDDD michigo

This message has been edited. Last edited by: Kerry,

Are you familiar with the ALL parameter?

As in SET ALL = ON ?

You have what is commonly referred to as a short path error.

Look at the documentation for this parameter.

What are the tables? Sequential files? SQL tables? Focus files?

Please also update your signature with platform and version info.

Daniel,

it is sequential file.

Raghuraman,

Are you files sorted by empcode?

See my example which works the way you want:

  
-* File Raghuraman1.fex
SET HOLDLIST=PRINTONLY

-*Only 3 records here
TABLE FILE CAR
SUM SALES/I5S
BY COUNTRY
IF COUNTRY LE ITALY
ON TABLE HOLD AS H1
END

-* 5 records here
TABLE FILE CAR
COUNT CAR
BY COUNTRY
ON TABLE HOLD AS H2
END

-* All 5 records and the joined fields here
JOIN COUNTRY IN H2 TO COUNTRY IN H1 AS Z

TABLE FILE H2
PRINT *
END

As stated above just set the ALL option. You want a left-outer join and this will give it to you.

SET ALL = ON

join empcode in emp to empcode in pltdetial as jo1

table file emp
print empcode emploc pltcode
end