union/intersect vs. or/and semantics
659140Jun 2 2009 — edited Jun 2 2009Hello...
I have non-correlated subqueries that are currently using or/and operators between each of the subqueries.
For example
sub_query_1
OR
sub_query_2
The questions are:
1. if I change the OR operator to an INTERSECT operator, does that return the same results?
2. Are the semantics of OR/INTERSECTS, AND/UNION the same?
Thanks,
Jim