To bzszp:我用同一张表做了个列select * from table1 where id in(select id from table1);可以运行, 为什么 select * from table where id exists(select id from table1) 会抱错??"invalid relational operator"???
select * from table where exists(select 1 from table1 where id=table.id)
为什么
select * from table where id exists(select id from table1)
会抱错??"invalid relational operator"???