your query uses a LEFT OUTER JOIN but the query doesn't actually use any of the right table's columns, so i think you can just remove the join SELECT * FROM messages WHERE siteId = @siteId ORDER BY threadDate DESC , COALESCE(a.parentGUID,a.GUID) , datePosted -- rudy http://r937.com/