Incorrect syntax near the keyword 'order'.Select CityName, idCity, CityUrl from Cities where IDState = order by CityName