delete rows from two tables using one sql statement

[vikysaran]

Hi,
i want to delete rows from two tables using one sql statement.

One table is tblEmployee and other is tblUser and i want to delete all record in both of table whose UserID is EE00001

[sakumar9]

1. This is not possible by a single DELETE statement;
2. You can write a stored procedure or function to do so;
3. You can implement some primary-key, foreign key relationship(if possible), and delete from parent table (use ON DELETE CASCADE option), this will delete rows from both tables;


Regards
-- Sanjay