1-) MSSQL Athena -  left outer

SELECT ISNULL(SGKMESLAN_TEXT,'') AS SGKMESLAN_TEXT,SGKMES.* FROM SGKMES LEFT OUTER JOIN  SGKMESLAN ON(SGKMES_RECNO=SGKMESLAN_JOIN_REFNO AND SGKMESLAN_LANGUAGE='TR') WHERE SGKMES_DRM='0'