Multiple Inner Joins

[comfygringo]

I can't get this right no matter how hard I try. Any help would be appreciated.

SELECT Salutation.Salutation, valid_numbers.[first name], valid_numbers.[last name], ([house number] & Chr(32) & [street name]) AS address, city, st, zip, (security.[first name] & Chr(32) & security.[last name]) as Agent
FROM valid_numbers 
INNER JOIN salutation 
INNER JOIN security 
ON security.userid = valid_numbers.userid
ON Salutation.ID = Valid_Numbers.Salutation 
where [send letter] = true and [letter sent date] is null

[orange]

see r937's post #3 here for syntax

http://www.dbforums.com/microsoft-ac...ee-tables.html

[June7]

Are you using the query designer to help build the SQL statement?

[comfygringo]

No. Maybe I should try that.

[comfygringo]

I solved it using the example thread that you provided. I just needed to put parenthesis in the right place.

Thanks!

[June7]

The query builder is very useful to help construct SQL statements that can then be pasted into VBA code and adjusted as needed.