Query Menu

To access the query menu, click on Query in the Query Editor window.

• Add Table:
  If you would like to add a table, select Add Table...  This will take you to a menu that will list all the tables avaliable to you.  Select your table and click the Add button.  After you finish adding more tables, click the Done button.  Based on the PSQL options that are selected, JReport will Auto Join the new table together with the previous tables.  Click the Arrange button or click Query/Arrange Tables to organize these tables.   
  
  Adding tables with the same name
  If you add a table with the same name, the following window will appear:
  
  
  
  You must type a new alias as the title of the new table.
  
  
• Show Table Names:
  This gives you the option on which table each field in the Criteria menu belongs to.
  
  
  Without Table Names                    With Table Names
  
  
  
• Show Mapping Names:
  This option allows you to see the full name of the field in the tables in the Query tab.
  
  
  Without Mappings                   With Mappings
  
  
  
• Auto Join: Click here for more information.
  
  
• And...: Click here for more information.
  
  
• Join Columns: Click here for more information.
  
  
• Current Query Options:  Click here to view infomation about this subject.