outer join
Need help creating a view. Here my view
CREATE OR REPLACE VIEW B_Public_Safety_LOG AS
SELECT
      BO.SubscriptionName,
      BO.actionCode,
      BO.SubscriptionIdentity,
      BO.APPLICATIONTAG,
      WK.workItemId,
      WK.workItemType,
      WK.CREATETIME,
      WK.CreatedByid,
      WK.COMPLETETIME,
      MI.targetComplnTime DueDate,
      WK.STARTTIME,
      JPC.DESCR,
      TA.TASKMODELNAME
FROM
      WM_WORKITEM       WK,
      taskmodel      TA,
      JEOPARDYCODEUMT   JPC,
      WI_Milestone   MI,
      WI_MODEL   WI,
      B_Public_Safety BO
WHERE
      BO.WorkitemId=WK.WorkItemId and
      BO.WorkitemId=MI.WorkItemId(+) and
      JPC.intcode=WK.ADMINSTATECODE and
      MI.milestoneTypeCode = 'COMPLETE' and
      BO.WorkitemId=WI.WorkItemId(+) and
      WI.PARENTINSTANCEID is null and
      WI.TASKMODELID=TA.TASKMODELID;
When the following tables have no rows, I would like the view to display the rest of the other columns and NULL for the columns from these tables.