I am basically new to t-sql and have the following temp table questions: 1. I am wondering what is a better idea to use temp tables or alot of left joins to solve complex query issues? If so, can you tell me what is better and why? 2. If temp tables are a better solution, I know that temp tables take room from tempdb. If there some procedure I could follow to make certain that I restore the space to tempdb? Let me know if doing a table create and then an insert into table is better to use that a select field(s) into new table? 3. If using more left joins is a better solution, can you tell me why? 4. is using several left joins with one or two temp tables a good idea?