I am creating query using SQVI, I want to join three asset tables. when I join them, I click on execute , I get the message that no lists exists. Then i click on display and double on fields I need from each table in layout mode. But still when I run the query, i get the message that no list exist.
However, when I choose Basis mode to select fields and click on execute , I get the message "Generation of query XYZ failed due to inconsistencies in the query".
What is the proper way of creating the query? What next do I need to do, once I have joined he tables. Do I need to select the fields I want from each table, if yes, what next has to be done.