34,594
社区成员
发帖
与我相关
我的任务
分享一个查询的简单问题?
select orderid , orderdate from orders
where customerid in select customerid from customers where country = 'UK'
这条语句报错,是SQL SERVER 不支持IN 操作符呢还是我的语法有问题啊,SEQUEL应该支持IN操作的啊
where customerid in select customerid from customers where country = 'UK'
这条语句报错,是SQL SERVER 不支持IN 操作符呢还是我的语法有问题啊,SEQUEL应该支持IN操作的啊
...全文
请发表友善的回复…
发表回复
nintha 2004-08-31
- 打赏
- 举报
谢谢指导!
Andy__Huang 2004-08-31
- 打赏
- 举报
加個括號
select orderid , orderdate from orders
where customerid in (select customerid from customers where country = 'UK' )
select orderid , orderdate from orders
where customerid in (select customerid from customers where country = 'UK' )
yesterday2000 2004-08-31
- 打赏
- 举报
select orderid , orderdate from orders
where customerid in (select customerid from customers where country = 'UK' ) a
where customerid in (select customerid from customers where country = 'UK' ) a
