A working SQL select bombs out when changed to delete

["Valerio Vincenti" <vvincenti@xxxxxxxxxxxxxxxxxx>]

Hi all,
 
I need to delete from file A all the records that are matched to file B (via a unique key field), but only those where a field on the file B contains a specific value (Batch Number = 1060).
 
I started off with a select statement to make sure I target the right records.
The following works fine:
 
select T6C8N1 from PPRPTEST/BBT6CPP as DCL     
              inner join PPRPTEST/BFEYCPP as RF
              on DCL.T6C8N1 = RF.EYG9N2        
              where RF.EYHDN2 = 1060           
 
I replaced the select with a delete:
 
delete from PPRPTEST/BBT6CPP as DCL            
              inner join PPRPTEST/BFEYCPP as RF
              on DCL.T6C8N1 = RF.EYG9N2        
              where RF.EYHDN2 = 1060
 
This issues error: Keyword INNER not expected. Valid tokens: <END-OF-STATEMENT>.
 
I tried without the aliases, but I get the same error.
 
What am I missing?
 
TIA           
 
 
Valerio Vincenti
IT Business Analyst
County of Spotsylvania, I.S. Department
Spotsylvania, VA 22553
Phone (540) 507-7507
Fax (540) 582-9841
e-mail: vvincenti@xxxxxxxxxxxxxxxxxx