I figured out where I was going wrong.

I used the technique you had suggested above, minus the join, and it wasn't working, however. I was using tableName.columnName to access the data in...

I'm not sure what you mean by more clear, however I will endeaver to comply.

database1           database2

   table1                  table2

           results set from

          database1 - table1

          database2 - table2

The data is not coming from two...