Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    50

    Arrow Unanswered: outer join with a constant

    Hi,

    How can we achieve outer join with a constant.

    I mean something like following :

    select t1.col1 , t2.col1
    from table1 t1, table2 t2
    where t1.col1 = t2.col1(+)
    and t2.col2 = 5 (+)

    Thanks,
    Ishan

  2. #2
    Join Date
    Mar 2004
    Posts
    50
    The solution is :

    select t1.col1 , t2.col1
    from table1 t1, table2 t2
    where t1.col1 = t2.col1(+)
    and t2.col2 (+) = 5


    Thanks,
    Ishan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •