Selecting Records from Non-Unique Id Tables Using SQL Join Types and Subqueries

Avoiding Extra Columns in Having Clauses with QoQ and ColdFusion