I have 6 tables with the same design but the data is different because they are pulling data from 6 different places (it is an ODBC connection to other databases).
I want to create a report that will show me the id for each row.
The table design is: employeeID, SSN, Name ....
So, I want a report that will show me every SSN and for each SSN, I want to see the employeeID (if it exists) for each table.
The columns for the report would be: SSN, employeeID1, employeeID2, employeeID3, employeeID4, employeeID5, employeeID6
Any ideas? Thanks!