Tuesday, February 14, 2012

Delete more than one table

Is it possible to write SQL to delete data in more than one tables?
Something like this
Delete * from tableA and tableC and tableB where dat<>date()No, a SQL DELETE statement affects only one table - unless your particular DBMS does things differently.|||Thanks you very much. :)

No comments:

Post a Comment