Query populates with N/A's or doesn't respond

[VBAguy22]

Hi
I have a select query that's using an oracle linked table and joins it to another query by memberId.
When I try to sort the results, the query freezes or populates with N/A's.
I have to do it in two steps for some reason.
Does anybody know why?
The tables are rather small (couple of thousands) so that couldn't be the issue.

 

[hneal98]

What does the query look like? What does the data look like from the tables? What are you trying to get?