SQL Language (MOSC)

MOSC Banner

outer join

edited Apr 25, 2012 6:34PM in SQL Language (MOSC) 6 commentsAnswered
Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center