So i have the following query which i'm using in various ways to find records in one table that are not in another:
SELECT offenseno FROM offense.dbo.off_per t1
WHERE OFFENSENO not IN (SELECT OFFENSENO FROM offense.dbo.offense t2 WHERE t2.OFFENSENO=t1.OFFENSENO)
i'm wanting the resultset for the times i run this against different tables to be dropped into a new table. I've tried tacking a "Select * into " portion at the beginning and turning the above into a subselect, but I'm in syntax hell. So, how do i use the above to make a select into for a new table?