SELECT DISTINCTROW [Mailings].[MailingName], [FirstName] & " " & [LastName] AS [Member Name], [Members].[HomePhone], [Members].[WorkPhone], [Members].[Extension], [Members].[FaxNumber] FROM [Members] INNER JOIN ([Mailings] INNER JOIN [MailingMembers] ON [Mailings].[MailingID] = [MailingMembers].[MailingID]) ON [Members].[MemberID] = [MailingMembers].[MemberID];

Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '.'.