when using delete join pop out E_US09C4 Syntax error on line 1

Question

I am using Vector Version VW 4.2.2. When I use delete join, one error pop out, E_US09C4 Syntax error on line 1. Could anyone help solve this? Thanks very much. Below is my sql script:

delete T.* from table1 T
join table2 F
    on T.collective_Id = F.portfolio_id
    and T.activity_Year = F.activity_Year
    and T.activity_month = F.activity_month