Thanks! After several attempts and revisions, the script is working the way I want it do!
I have a table (Table1) where one of the columns is the ID (Table2ID) for a second table (Table2). I know how to query Table1 and get all of the values, my issue is to be able to return the corresponding Name from table 2. I'm stumbling over NULL and available ID. Any assistance would be appreciated. Thanks!