Based on your comment, I propose you use LEFT OUTER JOIN:
The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match
Example:
SELECT EATTM002.*, EATTM001.*
FROM EATTM002
LEFT JOIN EATTM001 ON EATTM001.COL2 = EATTM002.COL2
All from EATTM002 and matching ones for EATTM001 will be retrieved.