vba issue with inner join

[joetinger]

Hello I'm trying to connect to my db using an inner join

str = "SELECT CCSMS.CUST_NO " _
    & "FROM CSPCL INNER JOIN CCSMS " _
    & "ON CCSMS.CUST_NO = CSPCL.CUST_NO "

I keep getting the error

thanks,
JO