inner join syntax error

[Venus]

Put a space before each double-quote. I don't know if you put it on multiple lines for demonstration purposes on this board or it's all on one line in code but the way you have it written, would translate into
SELECT SYSTEM.EMAILFROM CUSTOMER INNER JOIN SYSTEMON CUSTOMER.ID = SYSTEM.IDWHERE (((CUSTOMER.STATE) = '" & mySt & "')) " the ones in bold are missing spaces.

Try

strSQL = "SELECT SYSTEM.EMAIL " & _
"FROM CUSTOMER INNER JOIN SYSTEM " & _
"ON CUSTOMER.ID = SYSTEM.ID " & _
"WHERE (((CUSTOMER.STATE) = '" & mySt & "')) "