I *think* I read recently that using the Oracle (+) operator can give you the er... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		fendale on Nov 9, 2011 \| parent \| context \| favorite \| on: "I've isolated the bug to a database query" I think I read recently that using the Oracle (+) operator can give you the error "cannot outer join to more than one table" if you try to outer join to two or more, but the ANSI syntax will allow you to do that - I really should test this out ... edit - I tried this out and right now cannot get that error, so not sure where I got that idea from.

LewisCr on Nov 10, 2011 [–]

This code:

    Where a.client_id = c.client_id
    And a.client_id = b.client_id (+)
    And c.client_id = b.client_id (+)

Doesn't fly in our database

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact