I think what is making this a bit trickier is that I want to be able to use ONE query for both users.

So for example:

Table A has a...