Delete in SQL

["Bruce Barrett" <bruce.barrett@xxxxxxxxxxxx>]

Do you know how to write a delete statement to delete by a composite
key/

I can do it by one, but 3 doesn't seem to work

This is the last one I tried
                            Specify DELETE Statement

 

 Type choices, press Enter.

 

   File . . . . . . . . . . .   ISPFDWJS                 Name, F4 for
list      
     Library  . . . . . . . .     waide                  Name, F4 for
list      
   Correlation  . . . . . . .                            Name

 

 Type WHERE conditions, press Enter.

   in (select * from waide/dq32pf2 where ctidwj=ctidwja and
ctckwj=ctckwja      
   and sccswj=sscswja)

 

 
Bottom 
 Type choices, press Enter.

 

   WITH isolation level . . .   1                1=Current level, 2=NC
(NONE)   
                                                 3=UR (CHG), 4=CS, 5=RS
(ALL)   
                                                 6=RR

              F10=Copy line   F12=Cancel   F14=Delete line   F
Token WAIDE was not valid. Valid tokens: ) ,.   


This is what we normally run----(but I need the sccswj field to make it
unique)

DELETE FROM ISDTAPRD/ISPFDA3 WHERE bfnba3 in  (SELECT * FROM  
 waide/dq138SMC)                                               


Bruce Barrett
Systems Consultant
PMI Mortgage Insurance Co.
925-658-6152
bruce.barrett@xxxxxxxxxxxx

This e-mail is confidential and may be privileged. If you are not the
intended recipient, please destroy this message and notify the sender.