Actually, now that I think of it, I do have a question. I referred to some tables multiple times in that query. I wasn't sure if I could give an abbreviation once and then use the same abbreviation each time I referred to that table, or if I had to keep giving the abbreviation each time I referred to the table, and in the latter case I wasn't sure if I could use the same abbreviation each time. So I went with giving the tables a new abbreviation each time I referred to them, just to be on the safe side. It works, but is this the most efficient way to do this? Can I just give the table abbreviation once? Or if I have to give it each time, can I give it the same abbreviation each time?