Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    12

    Unanswered: help in temp tables

    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);

  2. #2
    Join Date
    Feb 2007
    Posts
    4
    SELECT DISTINCT Client.id
    INTO TempTable
    FROM Client
    WHERE Client.Active='YES' AND Client.id NOT IN (SELECT Client_ID_Monthpayed FROM MonthPayed Where Month_Payed=Insert_Month);

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •