intersect function

From: burke (anonymous_at_discussions.microsoft.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 15:15:31 -0800

i just came across the "intersect" function and can't get
it to work. i'm familiar with "union".

i've copied the example from books online and i get the
following error:

[Microsoft][ODBC SQL Server Driver]Syntax error or access
violation

i've tried to substitute "union" with "intersect" in a
union statement that works and get the following error:

Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'intersect'.

heres the sample statement:
select id, status, member_type
from imis.dbo.name n
where member_record = 1

intersect

select id, status, member_type
from imis_2003_q4.dbo.name n
where member_record = 1

we're on sql server 2000

thanks for any help.

Relevant Pages

  • Re: Are the following set operations true?
    ... >C in (A intersect B), C in (A union B),. ... disproofs. ... here are some basic questions you should be able to answer before ...
    (sci.math)
  • Re: algorithm to INVERT a multiarea selection ?
    ... specialcells with the union to return the inverse. ... > Then create an array of same dimensions... ... much faster then checking intersect during a 'normal' loop. ... > moment..and I'm pretty sure there must be some nice routines out there! ...
    (microsoft.public.excel.programming)
  • Re: intersect function
    ... Intersect is for Analysis services, use UNION or UNION ALL to not eliminate ... > [ODBC SQL Server Driver]Syntax error or access ... > union statement that works and get the following error: ...
    (microsoft.public.sqlserver.mseq)
  • Re: Possible Proof of the Lusin-Purves Theorem
    ... >> they should converge in the original topology on XxY, ... union of singletons, thus Borel. ... = clintersect ^c ...
    (sci.math)
  • Re: Possible Proof of the Lusin-Purves Theorem
    ... >> they should converge in the original topology on XxY, ... union of singletons, thus Borel. ... = clintersect ^c ...
    (sci.logic)