vliet (10/8/2009)

---

Since the 'or' operator has lower precedence as the 'and' operator, when you ommit the parentheses the join condition means something completely different. Without parentheses the predicate behind the...

Right Now, results are same as there are no null values for b.date2 .

"b.date2 is null" is a precautionary statement.

That's why, i want to know whether logically both queries are...

Good Article,

I have a question on Joins.Can anyone help me.

When I run below query it is running for 40 mins as it is using Table Spool.

Query:

select a.*,b.*

from table a

left join...