Table join problem- "no data was selected"
I've created a table join of tables PA0000, PA0001, PA0002, PA0077 and T5U13. But when I try and execute an ad hoc query, I get a message that says "No data was selected." I am trying to create a query with EEO info...I need to be able to input personnel number or employment status (PA0000), need to display the employee's subgroup, position and job (PA0001), their first and last name (PA0002), and ethnic code (PA0077). From T5U13, I need the EEO category. I've already tried building a query using PNP and PNPCE but was not successful. What step(s) am I missing? Thanks for any guidance you can provide.