12 Replies Latest reply: Nov 19, 2014 10:26 AM by C Supak RSS

    how to use temp table in sql queries

      Hello,

      I want to limit the results from one table on the 'Firm_Key' value. I also want to use the same limitation on several other tables, but which do not have the column 'Firm_Key'. The tables do share an 'Account_Index' column. All my attempts give errors. Thank you for your help.

      tblFiltered:

      SQL SELECT * FROM Table1 WHERE Firm_Key='myFilterValue';


      SQL SELECT * FROM Table2 as A
      INNER JOIN tblFiltered as B ON A.Account_Index = B.Account_Index;