Below is my temp table and query – I am assuming I can inner join or use a different condition in the where clause. Where do I filter the final output of the temp table and how? Do I do the inner join in the temp table or in the query below it inner joining the temp table to the main data? I have a left join with the temp table, do I just switch that to be a inner join?