PostgreSQL用内部连接删除
发布时间:2020-12-13 16:52:16 所属栏目:百科 来源:网络整理
导读:DELETE B.* FROM m_productprice B INNER JOIN m_product C ON B.m_product_id = C.m_product_id WHERE C.upc = '7094' AND B.m_pricelist_version_id = '1000020' 我得到以下错误PostgreSQL 8.2.11 ERROR: syntax error at or near "B"LINE 1: DELETE B.* f
DELETE B.* FROM m_productprice B INNER JOIN m_product C ON B.m_product_id = C.m_product_id WHERE C.upc = '7094' AND B.m_pricelist_version_id = '1000020' 我得到以下错误PostgreSQL 8.2.11 ERROR: syntax error at or near "B" LINE 1: DELETE B.* from m_productprice B INNER JOIN m_product C ON ... 我试过给 DELETE B from m_productprice B INNER JOIN m_product C ON B.... ERROR: syntax error at or near "B" 我试过给 ERROR: syntax error at or near "INNER" LINE 1: DELETE from m_productprice B INNER JOIN m_product C ON B.m_... 我的查询有什么问题? DELETE FROM m_productprice B USING m_product C WHERE B.m_product_id = C.m_product_id AND C.upc = '7094' AND B.m_pricelist_version_id='1000020'; 要么 DELETE FROM m_productprice WHERE m_pricelist_version_id='1000020' AND m_product_id IN (SELECT m_product_id FROM m_product WHERE upc = '7094'); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- Postgresql服务器没有要求远程连接的密码
- 10分钟掌握XML、JSON及其解析(上)
- c# – 如何自定义WPF功能区4.5(样式,模板等)
- fastjson 处理null值,对象为null时返回{},数字为null返回[
- c# – 尝试重新启动线程时发生ThreadStateException
- 使用NM-16ESW模拟交换机--使用经验
- Cross Plattform使用Swift为OS X和iOS构建目标?
- 在C中使用对象之前总是检查空指针是很好的编程习惯?
- 精益 React 学习指南 (Lean React)- 3.4 掌控 redux 异步
- 一个时代的终结 —— 再见, Flash !| 源资讯