PL/SQL (MOSC)

MOSC Banner

How to deal with this join situation?

edited Sep 19, 2019 5:06AM in PL/SQL (MOSC) 3 commentsAnswered

Hello,

My agency has a request in a project with Treasury (IPP) and here is the situation in which we have tried a few days but getting no where:

  • Two tables:  Table1 (col1, col2), Table2 (col1, col3)
  • Table2 has rows only when a condition is met for Table1.  So Table1 may have 10 rows and Table2 only 2.  For those two rows, co1 is the same as Table1.col1 but col3 could be the same as Table1.col2, or different
  • we need to query all distinct rows from both tables (we try left outer join here)
  • for Table2.col3, if the value is dfferent from table1.col2, we need to have this value

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