Question

Access 在查询语句的时候出现 操作符丢失 如何解决？

SELECT Snofrom SCwhere Cno=1intersectselect Snofrom SCwhere Cno=2;提示 语法错误 操作符丢失如何修改

Answer 1

第一你少空格，第二语法也不正确。 SELECT Sno from SC where Cno=1 union allselect Sno from SC where Cno=2 或SELECT Sno from SC where Cno=1 or Cno=2或SELECT Sno from SC where Cno in (1,2)

Answer 2

SELECT Sno from SC where Cno=1 ;select Sno from SC where Cno=2; 可改成 SELECT Sno from SC where Cno =1 or Cno = 2;