If your report has fields from more than 1 table you need to tell Sequenchel how the tables are related to each other. If relations are known Sequenchel will display those relations but leave it up to you to select the correct one. If the correct relation is defined all you need to do is select the “Use” checkbox. If the relation you need is not defined you must enter it manually.
“Source Field” contains a list of all the fields from the corresponding table. Select the field that has a relation to the other table you wish to use. This is usually an ID field.
“Relation” is the table name and fieldname the Source Field is related to. This is usually a Primary Key field. Write this down as schema.table.field. You can see schema and table name in the list with selected tables. Use the name between the brackets, the other name could be an alias.
Select the correct type of relation in the “Join Type”
INNER: The value must exist in both tables. Non matching rows/values are left out.
LEFT OUTER: Use all values from the first (left) table and supplement with values from the second (right) table if they exist.
RIGHT OUTER: Use all values from the second (right) table and supplement with values from the first (left) table if they exist.
FULL OUTER: Use all values from both tables and connect them where possible.
CROSS: combine all values from both tables with each other. This may result in a very large result set.
Make sure the table where most of your fields come from is listed first. The order determines how the relations are build.