On Thu, Apr 16, 2009 at 3:24 PM, Sarah Adams <sarahwbs at gmail.com> wrote: > I was thinking this might return a full set of all set/option combinations: > > SELECT o.OptionID > , CONCAT(s.NameDE,': ',o.NameDE) AS SetOption > FROM OptionSets AS s > INNER > JOIN Options AS o > ON o.SetID = s.SetID > GROUP > BY o.OptionID > > I'm hoping the optimizer can figure it out. It will only operate on those records which match the join condition. This includes the concat() function and the grouping. You can verify this by running an explain on the query and looking at the order of operations. -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.