SELECT a.ID,a.Times,a.Content, a.Priority, S.Content, a.Values, u.UserName FROM ((Alarms AS a LEFT JOIN [States] AS S on a.StateID= S.ID) LEFT JOIN [User] AS u ON a.UserID = u.id ) order by a.Times desc
'(' and ')' is needed, or else there will be an error.