Search code examples
sqloracle-databaseplsqlansi-sql

What is the equivalent of (+)<2 in ANSI SQL?


I want to turn this

TableA.ColumnA(+)<2

into ANSI SQL.

I already tried:

(TableA.ColumnA<2 OR TableA.ColumnA IS NULL)

It missed one row. Despite the fact that its ColumnA is (null).

Edit (more context): Here is the query

SELECT * FROM a, c 
WHERE a.status(+)<2
AND a.rank(+)=1
AND c.id=a.id(+)

Solution

  • give this a try

    SELECT * FROM c LEFT JOIN a
    ON c.id = a.id
    AND a.status < 2
    AND a.rank = 1