I am looking for a way to get an intersection of 2 tables in a SQL Server 2000 database. I know 2005 offers this functionality built in, but 2000 lacks this. I'm guessing there is still a way to accomplish this with what 2000 does offer, probably with some tricky subqueries, but I haven't been able to figure it out yet.
Basically I have 2 tables that have a CaseNumber field and I want to get a recordset that lists the CaseNumbers that appear in both table1 and table2. Anyone have some SQL code lying around that will accomplish this? Thanks in advance.