select cid from orders where pid='p01'intersect cid from orders where pid='p07';
提示说interscect附近语法错误，帮忙分析下，cid为列名，orders为表名

INTERSECT(相交): 返回两个表中共有的记录
SELECT * FROM FOOTBALL INTERSECT SELECT * FROM SOFTBALL
SQL2000的Select语句暂不支持；


Intersect(集合1，集合2[,ALL])
需要安装Analysis Services