MySQL: In a select with aggregate functions, how to join two columns not in aggregate functions? November 29, 2022 by MagenautI’m using Viescas’ SQL Queries for Mere Mortals, and its datasets.