How to delete records of a table when its primary key is referred as a foreign key in another table in a single query?
如何在单个查询中将其主键称为另一个表中的外键时删除表的记录?
1 个解决方案
#1
0
DELETE * FROM table1 FULL OUTER JOIN table2 ON table1.(Primary key column name) =table2.(Foreign key column name);
DELETE * FROM table1 FULL OUTER JOIN table2 ON table1。(主键列名)= table2。(外键列名);
try this
#1
0
DELETE * FROM table1 FULL OUTER JOIN table2 ON table1.(Primary key column name) =table2.(Foreign key column name);
DELETE * FROM table1 FULL OUTER JOIN table2 ON table1。(主键列名)= table2。(外键列名);
try this