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!