Page 1 of 1

access multi left join

Posted: 25 Feb 2019 23:47
by jiataifeng
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.