access multi left join

Keep Open and Learning
Post Reply
jiataifeng
Posts: 176
Joined: 30 Apr 2009 06:31

access multi left join

Post by jiataifeng » 25 Feb 2019 23:47

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.

Post Reply