DECLARE @t1 TABLE(
id INT,
col1 CHAR(1),
col2 SMALLINT,
col3 CHAR(1),
col4 CHAR(1),
col5 CHAR(1)
)
 
INSERT INTO @t1 VALUES (1,'a',10,'z','z','z');
INSERT INTO @t1 VALUES (2,'b',20,'z','z','z');
INSERT INTO @t1 VALUES (3,'c',30,'z','z','z');
INSERT INTO @t1 VALUES (4,'d',40,'z','z','z');
 
DECLARE @t2 TABLE(
id INT,
col CHAR(1),
col2 SMALLINT,
col3 CHAR(1),
col4 CHAR(1),
col5 CHAR(1)
)
 
INSERT INTO @t2 VALUES (1,'a',10,'z','z','z');
INSERT INTO @t2 VALUES (2,'b',20,'z','z','z');
INSERT INTO @t2 VALUES (4,'d',30,'z','z','z');
INSERT INTO @t2 VALUES (5,'e',40,'z','z','z');

--intersect
SELECT *
FROM @t1

INTERSECT

SELECT *
FROM @t2

--equivilant
SELECT 
	t1.*
FROM @t1 t1
INNER JOIN @t2 t2
	ON  t1.id = t2.id
	AND t1.col1 = t2.col
	AND t1.col2 = t2.col2
	AND t1.col3 = t2.col3
	AND t1.col4 = t2.col4
	AND t1.col5 = t2.col5

<!--- missions query --->
    <cfif isdefined ("m") and comparenocase(m,"")>
    <cfif mission_operand EQ 'Match All  (AND)'>
    <cfloop index="i" list="#m#" delimiters=",">
    INTERSECT
    (SELECT objectid FROM OC4_OBJECTATTRIBUTEMAP where attributeid = #i#)
	</cfloop>
    <cfelseif mission_operand EQ 'Match Any  (OR)'>
    INTERSECT (SELECT objectid FROM OC4_OBJECTATTRIBUTEMAP where attributeid IN (#m#))
      </cfif>
    </cfif>
    
    <!--- topics query --->
    <cfif isdefined ("t") and comparenocase(t,"")>
    <cfif topic_operand EQ 'Match All  (AND)'>
    <cfloop index="i" list="#t#" delimiters=",">
    INTERSECT
    (SELECT objectid FROM OC4_OBJECTATTRIBUTEMAP where attributeid = #i#)
	</cfloop>
    <cfelseif topic_operand EQ 'Match Any  (OR)'>
    INTERSECT (SELECT objectid FROM OC4_OBJECTATTRIBUTEMAP where attributeid IN (#t#))
      </cfif>
    </cfif>