MS SQL > PG 로 바꿀때 outer apply

outer apply => LEFT JOIN LATERAL 

ON true

SAMPLE :

FROM A

LEFT JOIN LATERAL
(
   SELECT CODE_NO  CODE_NAME
   FROM B
   WHERE A.CODE_NO  =B.CODE_NO  
   ORDER BY A.CODE_NO
   LIMIT1
) S8_1 ON true

isnull => coalesce