vba sql query

[joetinger]

Thanks the reply. I updated my query and am now receiving the error below

str = "SELECT CWIPH.CUST_NO, CCSMS.CUST_NO " _
    & "FROM (CWIPH INNER JOIN CCSMS ON CWIPH.CUST_NO = CCSMS.CUST_NO) "