[thelist] Weird SQL problem with INTERSECT and UNION

[Ken Schaefer]

I see no T-SQL function "intersect" in my copy of Books Online...

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <tss24 at cornell.edu>
Subject: [thelist] Weird SQL problem with INTERSECT and UNION


: So I've got this MS SQL problem and can't seem to 
: figure it out.
: 
: If I run this query (notice only difference is cost):
: 
: ((SELECT C.pid, C.cost, S.sname, P.pname 
:    FROM Catalog C, Suppliers S, Parts P 
:    WHERE C.pid=1 AND C.cost >0.00 
:      AND C.sid=S.sid AND C.pid=P.pid) 
: 
: UNION 
: 
: (SELECT C.pid, C.cost, S.sname, P.pname 
:   FROM Catalog C, Suppliers S, Parts P 
:   WHERE C.pid=1 AND C.cost >10 
:    AND C.sid=S.sid AND C.pid=P.pid)) 
: 
: I get the correct results in Query Analyzer.
: 
: However, if I change UNION to INTERSECT, I get an 
: error near INTERSECT it says.
: 
: Any ideas? Am I doing something wrong with my 
: INTERSECT query?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~