hello i have this sql code in a query (ms office 2007), its working fine and giving the results how do i put that into a temporary table? i have no idea how to create it and what is the sql code to be added
SELECT DISTINCT Client.id
FROM Client
WHERE Client.Active='YES' AND Client.id NOT IN (SELECT Client_ID_Monthpayed FROM MonthPayed Where Month_Payed=Insert_Month);