...
- Join name: A unique string, used to identify this join
- Join type: Describes the type of join (e.g. LEFT OUTER, RIGHT OUTER, INNER) - this effects how the records are combined (see http://en.wikipedia.org/wiki/Join_(SQL)
- Table name: The full name of the table to join to
- Join condition: This describes which fields the tables should be joined on. Use the Join name to describe other tables, or 'base' for the base table. In this case we are joining the 'category' field of the base (course) table, to the 'id' field of the course_categories table.
See also advanced join options.
Once the join has been defined, column options can make use of fields from the joined tables, by specifying which joined tables they will use. For example, to include a column option which displays the course category:
...