CODEWITHSUNDEEP
sqloracle-databasejoin
lexeme
lexeme

Reputation: 2973

Rewrite join to ANSI syntax

select ... fields
from table a, b
where ... conditions
and a.timeload between b.timestop(+) and b.timego(+)

I do understand how between operator works and I know that + operator here stands for left join. How do I rewrite it using ANSI joins standard?

Upvotes: 3

Views: 213

Answers (1)

Mahmoud Gamal
Mahmoud Gamal

Reputation: 79979

Use LEFT OUTER JOIN instead of the + operator.

For your query, it is a LEFT OUTER JOIN b:

select ... fields
from table a
LEFT OUTER JOIN b ON a.timeload between b.timestop and b.timego
where ... conditions

Upvotes: 5

Related Questions