SQL：如何从另一个表中删除行会议条件

I am able to identify the data I want with a select statement:

我能够用select语句识别我想要的数据:

SELECT  InventoryUnitMeasure.ItemCode, 
        InventoryUnitMeasure.UPCCode,  
        InventoryItem.ItemName
FROM InventoryUnitMeasure 
   INNER JOIN InventoryItem 
         ON InventoryUnitMeasure.ItemCode = InventoryItem.ItemCode
where ItemName like 'SNT%'

I then try to change to delete the column UPCode in table InventoryUnitMeasure like so but get an error:

然后我尝试更改以删除表InventoryUnitMeasure中的列UPCode,但是得到一个错误:

DELETE upccode from
FROM dbo.InventoryUnitMeasure
  INNER JOIN  InventoryItem 
     ON InventoryUnitMeasure.ItemCode = InventoryItem.ItemCode
where ItemName like 'SNT%'

I know I'm making a simple mistake but I just cannot figure it out and I've tried looking on multiple sites and multiple searches but I can only see how to delete a whole table when joining and not just a column.

我知道我犯了一个简单的错误,但我无法弄明白,我已经尝试过查看多个网站和多个搜索,但我只能看到如何在加入时删除整个表而不仅仅是一个列。

Any help would be greatly appreciated.

任何帮助将不胜感激。

I am using SQL Server as DBMS.

我使用SQL Server作为DBMS。

3 个解决方案

#1

Isn't DELETE statement used for deleting whole row? As i underestand your question, you should probably use UPDATE statement instead..

DELETE语句不是用于删除整行吗?由于我不满意你的问题,你应该使用UPDATE语句代替..

UPDATE table dbo.InventoryUnitMeasure SET upcode = null ...

Some hint on syntax can be here (quick google search)

语法上的一些提示可以在这里(快速谷歌搜索)

3 个解决方案

#1

更多相关文章

随机推荐