The SQL SELECT of your first query is sent to the SQL driver and executed by the driver / you DBMS.
Your resident table AccountTemp is part of the Qlik resident data model and unknown outside Qlik system, i.e. unknown to your SQL driver.
You need to join both tables within Qlik, using JOIN LOAD prefixes.
Within Qlik, you implicitely define the key fields for your JOIN by using same field names in both tables to join (remember to name every other field not to join differently in both tables).
If you want to apply a WHERE clause to either table, you can do this.