Proglem med join!

SQL = "SELECT C.ID, C.intUserID, C.strFile, C.strDate, C.strSize, C.intVarde, C.orderID, C.strVat, C.strInfo, C.strStatus A.strName, A.ID " _
& "FROM cart C join anv A on C.intUserID = A.ID "_
& "Order by C.ID"
Set RS = Connect.Execute(SQL)

Jag får felmess:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.strName, A.ID FROM cart C join anv A on C.intUserID = A.ID Ord

Vad kan vara fel?