Joins or Subqueries?

• When you are evaluating one table based on the aggregate analysis of another table - use a subquery

• When you need to display and/or evaluate data from more than one table -use a join

• Sometimes it is just a matter of preference

Previous slide

Next slide

Back to first slide

View graphic version