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(+)
give this a try
SELECT * FROM c LEFT JOIN a
ON c.id = a.id
AND a.status < 2
AND a.rank = 1