Creating a SELECT query that outputs a table with columns from PI OLEDB Enterprise (PI AF) and PI OLEDB (PI Server) Database Branches

I am using PI SQL Commander Lite to query values for a random selection of PI Tags. Along with the snapshot values I am asked to provide the time, tagname, element, description, template, pointsource, location1, location2, location3 and full element relative path in PIAF. I can't seem to find location1, location2, location3 in PIAF under the PI OLEDB Enterprise branch but do see it in the piarch table under PI OLEDB Provider branch.

Is there a way to create JOIN of sorts between the PI OLEDB Enterprise and PIAF OLEDDB Provider so as to create a table with the requested columns found across tables from either Database? Are there any examples of this in use?