I have two tables file & users, I want to see the file info for each user for C:Users%USERNAME%Documents So e.g. this would get the info from ‘example’ documents: But the username is coming from the users returns Alternatively, there’s: Which provides the first part of the path, but still can’t get to join ‘Documents’ to end of query and