How to DELETE a row from 2 tables?

[tnonline]

Dear guys,

How to DELETE a row from 2 tables?

For one table, I can use SQL statement like this:

sql = "DELETE FROM Table1 WHERE Field1 = 'abc'"

Now I have 2 tables:
Table 1: includes 1 Primary Key and a Foreign Key (used to link to Table 2), and some other fields;
Table 2: includes a Primary Key (link to Table 1) and some other fields.

I want to DELETE a row from Table 1 based on Primary Key, and the coresponding row in Table 2 based on Foreign Key.

Any body know how to write a SQL statement for this? Please help me.

Thank a lot.

[ITCS]

Ban chiu kho hoc them hoac viet cau hoi bang tieng Viet thi se nhan duoc cau tra loi som hon!
(Mac du ai cung co the doc tieng anh, nhung van thay ngai khi nhin thay bai cua ban).

[kiddy]

I'm sorry I don't know

[temp2]

SELECT from one table then delete both?

[tom2]

Dear guys,

How to DELETE a row from 2 tables?

For one table, I can use SQL statement like this:

sql = "DELETE FROM Table1 WHERE Field1 = 'abc'"

Now I have 2 tables:
Table 1: includes 1 Primary Key and a Foreign Key (used to link to Table 2), and some other fields;
Table 2: includes a Primary Key (link to Table 1) and some other fields.

I want to DELETE a row from Table 1 based on Primary Key, and the coresponding row in Table 2 based on Foreign Key.

Any body know how to write a SQL statement for this? Please help me.

Thank a lot.
Delete from table1 ...
Delete from table2 ...

[vtnphong]

hình như phải delete from table2 trước, nếu ko nó bị đứt link

[minhpn]

dùng khoá có thuộc tính là DELETE CASCADE là OK: Khi xoá 1 bản ghi ở bảng chính (có primary key) thì bảng có Foreign Key sẽ tự động bị xoá theo.

[alone_night]

Ban chiu kho hoc them hoac viet cau hoi bang tieng Viet thi se nhan duoc cau tra loi som hon!
(Mac du ai cung co the doc tieng anh, nhung van thay ngai khi nhin thay bai cua ban).

Đúng lắm!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!