Getting Token <END-OF-STATEMENT> was not valid.

Here is my sql statement
DELETE FROM BPCSFTST/CMFL01 WHERE (Select * from

BPCSFTST/CMFL01 INNER JOIN BPCSFTST/IIML01 ON CMFL01.CFPROD

= IIML01.IPROD where iiml01.iityp

in ('P','Q','2','9') and cmfl01.CFFAC=' ')
I am getting

Error Token <END-OF-STATEMENT> was not valid. Valid tokens: < > = <> <= !<
Can anybody see the error
Thanks