Changing a UPDATE tbl1... FROM tbl1 MSSQL query

[David Wynter]

I have this query to convert. Not easy as far as I can see. The inner joins are easy but cannot see how to do the outer join parts of the query. Any pointers?

UPDATE SECM_SECURITY_UNIVERSE
SET NAME = RTRIM(SUBSTRING(UPPER(IFNULL(IFNULL(fii.ISSUER_SHORT_NAME, fii.ISSUER_LONG_NAME),'NO NAME, TICKER: '
+ fii.ISSUER_TICKER )),1,36)) +
IFNULL((' ' + CAST(CAST(bc.CURRENT_CPN AS DECIMAL(10,2)) AS VARCHAR(13)) + '%'), '') +
IFNULL(' ' + CAST(bc.MATURITY_DATE, AS VARCHAR(8)), ' PERP') +
IFNULL(' SR:' + RTRIM(SUBSTRING(bc.SERIES,1,6)),'') +
CASE WHEN cv.ASSET_ID IS NULL THEN '' ELSE ' CVT' END +
CASE WHEN ps.ASSET_ID IS NULL THEN '' ELSE ' PFD' END +
CASE WHEN asu.ISSUE_REG_TYPE IS NULL OR INSTR(su.NAME, '144A') OR INSTR(su.NAME, '(REGS)') THEN ''
ELSE ' ' + rrt.DESCRIPTION END
FROM SECM_SECURITY_UNIVERSE su INNER JOIN BOND_CORE_INFORMATION bc ON su.ASSET_ID = bc.ASSET_ID AND su.ASSET_ID > 0AND su.NAME IS NULL
INNER JOIN FI_ISSUER_INFORMATION fii ON bc.ISSUER_ID = fii.ISSUER_ID
INNER JOIN dbo.BOND_ISSUANCE_SUMMARY bis ON bis.ASSET_ID = bc.ASSET_ID
LEFT OUTER JOIN dbo.CONVERTIBLE_BOND_INFO cv ON cv.ASSET_ID = su.ASSET_ID
LEFT OUTER join dbo.PREFERRED_STOCK_INFORMATION ps ON ps.ASSET_ID = su.ASSET_ID
LEFT OUTER JOIN AIM_REF_REG_TYPES rrt ON su.ISSUE_REG_TYPE = rrt.CODE
WHERE NOT EXISTS (SELECT *
FROM SECM_WATCH_LIST wl WHERE wl.SECURITY_ID = su.SECURITY_ID

Thx.

David