DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how can we achieve this outer join

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    how can we achieve this outer join

    let's say we have 3 tables A, B, C

    on each table, we have two columns. On table A had one column outer join with table C and one column outer join with table B. On table B, I want the second column outer join to table C and I got the error:

    ORA-01417.

    how can I fix this porblem or anyone had diffent query to achieve the same goal???

    thanks
    Last edited by mike2000; 03-27-2003 at 05:58 PM.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dupe closing

Posting Permissions

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


Click Here to Expand Forum to Full Width