> 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? MS SQL doesn't support INTERSECT. Apparently you can use EXISTS or a JOIN instead. This page has some suggestions about how to translate from Oracle to T-SQL, which might help you: http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm Jason