Hi caskey,
Please find herewith attaching the solution regarding your problem.
solution 1:-
----------
SELECT A.NAME,B.CODE FROM TABLE1 A,(SELECT DISTINCT ID,VALUE,CODE FROM TABLE2 WHERE VALUE = 'S') B
WHERE A.ID = B.ID(+);
(or)
SOLUTION :- 2
--------
SELECT A.NAME,B.CODE FROM...