Unable to apply Query, Syntax Near If

Hello, I am trying to run a query to create a temporary table so I can do a join on it later in the query. It allows me to run the query and returns 1 column with the number of rows affect but I am ...