Got me the solution I needed. Wow, I can't believe I figured that out.Code:SELECT Application.ID, Application.Name, Favorite.ID AS Expr1, Favorite.Enumber, Favorite.ApplicationID FROM Application LEFT OUTER JOIN Favorite ON Application.ID = Favorite.ApplicationID ORDER BY (CASE WHEN Favorite.ApplicationID IS NULL THEN 1 ELSE 0 END), Application.Name




Reply With Quote