Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: outer join in ingres-openroad

    Hi everyone,

    i am trying to compile this code in an ingres db, openROAD:

    select a.field1 as :fld1,
    a.field2 as :fld2,
    b.msg1 as :msg
    from (tableA a LEFT OUTER JOIN tableB b ON a.field3 = b.msg1
    and (
    (a.field4 = b.msg2 and a.field5 = b.msg3) or
    (a.field6 = b.msg4 and a.field7 = b.msg5)
    )
    )

    but I get a compilation error (E_W400F0 syntax error) on the word 'OUTER'.

    I have tried to compile the SAME code WITHOUT the word 'outer' and it succeeds. but i need to do an outer join! and not only a left join (because there are some null fields in table b)
    what do I have to do?

    thank you

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    this is an oracle forum, not an ingress forum.

    You are using pl/sql with ingress there.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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