I'm trying to use the Query Editor to produce a report that includes the 'Location' field for an asset but I can't seem to find the right combination of table and column names to produce the output desired. I keep getting errors similar to this one in the 'Log' field:

 

The column prefix 'locationDef' does not match with a table name or alias name used in the query.

 

Can anyone help me by defining the correct table name, alias name and/or column prefix to allow my report to run and give me the 'Location' field output?

 

Thank you for your assistance.