1-) MSSQL Athena -  leftouter join or join

SELECT CPDEPT.*,CPWORK.*,*,PSICIL.*,PEKODE.* FROM PSODEH JOIN PSICIL ON(PSODEH_PSICIL_ID=PSICIL_NUM AND PSODEH_DRM=@DRM) JOIN PEKODE ON(PSODEH_PEKODE_ID=PEKODE_RECNO) LEFT OUTER JOIN CPDEPT ON(CPDEPT_RECNO=PSODEH_CPDEPT) LEFT OUTER JOIN CPWORK ON(CPWORK_RECNO=PSODEH_CPWORK )