On Thu, Feb 14, 2008 at 4:13 PM, <[EMAIL PROTECTED]> wrote: > Column 'location_city.dst' is invalid in the select list because it is not > contained in either an aggregate function or the GROUP BY clause. > > Not fimilar with MSSQL to be honest. > > Yes, MS SQL is strict and will not allow you to return columns as part of an aggregate query unless they are either part of the GROUP BY clause or aggregated with either a built-in aggregate function such as COUNT, SUM, AVG, MAX, MIN, etc., or else a user-defined function or subquery (as the error message indicates). If you're used to MySQL, it isn't so strict (but IMO should be).
Andrew
