Hello I posted this in the db section of the forums with no help so I figured I'd try here... I'm writing some vba code that accesses a db. I keep receiving the error posted below. The query works fine with two tables and a where but when I try a join (eventually I will need to add a third table). The query is posted below thanks for the help in advance.

Name: Capture.PNG Views: 364 Size: 5.0 KB

Code:
str = "SELECT CWIPH.CUST_NO, CCSMS.CUST_NO " _
    & "FROM CWIPH " _
    & "JOIN CCSMS ON CWIPH.CUST_NO=CCSMS.CUST_NO "
JO