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.