select pid from products p where not exites(select cid from costumers c where c.city='new york' and not exites(select * from orders x where x.pid=p.pid and x.cid=c.cid));
时间: 2024-04-16 11:29:00 浏览: 19
抱歉,你的 SQL 查询语句有一些语法错误。我帮你修正一下:
```sql
SELECT p.pid
FROM products p
WHERE NOT EXISTS (
SELECT cid
FROM customers c
WHERE c.city = 'new york'
AND NOT EXISTS (
SELECT *
FROM orders x
WHERE x.pid = p.pid
AND x.cid = c.cid
)
);
```
这个查询语句的目的是从 `products` 表中选择出那些在纽约('new york')没有未完成订单的产品。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)