我们可以使用join一次删除两个表中的一条记录吗 [英] can we delete a record at a time in two tables using join

问题描述

您好，

我们如何使用联接一次删除两个表中的一条记录.

此查询有什么问题
查询:

Hi frnds,

how can we delete a record at a time in two tables using joins.

what''s wrong in this query
Query:

delete from admin from client c INNER JOIN admin a on a.mstr_id=c.mstr_id where c.padm_id=2020

请更正此

Please correct this one

推荐答案

您应该对另一张表具有外键，并将其配置为级联删除.这样，如果没有更多引用，将删除该引用记录.看看更多信息的链接:
http://www.mssqlcity.com/Articles/General/using_constraints.htm [ ^ ]

祝你好运！

You should have a foreign key to the other table and configure it to cascade delete. In this way the referenced record will be deleted if there are no more references to it. Have a look at the link for more info:
http://www.mssqlcity.com/Articles/General/using_constraints.htm[^]

Good luck!

引用此链接:

http://stackoverflow.com/questions/2696565/deleting-records-from-multiple-tables-at-a-time-with-a-single-query-in-sqlserver [

Refer this link:

http://stackoverflow.com/questions/2696565/deleting-records-from-multiple-tables-at-a-time-with-a-single-query-in-sqlserver[^]

这篇关于我们可以使用join一次删除两个表中的一条记录吗的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！