JOINS to get all info with single qry--continued

• Use Aggregate Functions—inc. for single valued columns (to get a value)

• Alternative—Use GROUP BY for columns that have single value

• e.g., GROUP BY AdmLevel

• Use Outer Join if there is any chance of zero rows in the many side table

Previous slide

Next slide

Back to first slide

View graphic version