Wednesday, March 18, 2009

SQL - Delete in Two Tables

delete from a.doc_data where sur_doc_nbr in (select sur_doc_nbr from a.doc where deld=1)
delete from a.doc_attr where sur_doc_nbr in (select sur_doc_nbr from a.doc where deld=1)
delete from a.doc where deld=1
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)