Skip to Content
0
Former Member
Jul 06, 2009 at 04:25 AM

Creating Query

52 Views

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.