DELETE INNER JOIN查询 [英] DELETE INNER JOIN query

问题描述

大家好。



我想删除内连接到另一个表的表记录

Hi all.

I wanna to delete the table records that has inner join to another table

DELETE  DISTINCTROW

FROM  ((Ghesting INNER JOIN
        buyer ON Ghesting.fk_code_m_buyer = buyer.code_m_buyer) INNER JOIN
        kala ON buyer.code_m_buyer = kala.buyer_codem
WHERE(fk_code_m_buyer= ?) AND (kala.type_kala= ?) AND ( kala.model_kala=?)

确实我想用条件（WHERE）删除Ghesting记录表（kala.type_kala =？）AND（kala.model_kala =？）但显示语法错误。



如何使用旅店感谢删除查询中的er join语句？

非常感谢。

Indeed I want to delete "Ghesting" record table with condition(WHERE) (kala.type_kala= ?) AND ( kala.model_kala=?) but shows have syntax error.

How to use inner join statement in delete query ?
thanks a lot.

推荐答案

尝试 SQL SERVER - DELETE From SELECT Statement [ ^ ]。

这篇关于DELETE INNER JOIN查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！