Ant Organisation Ltd

Content list join

This dialog is used to define joins in queries.
Joining a table in the query allows additional queries to be added in to the query string in query dialog.
For example if you are querying a table called "student" which has a column called "college_id" which joins to the "college" table, set Table name="college" alias="student_col" and join condition="student.college_id=student_col.college_id".

Content query join dialog

Fields

Table name		Name of the table that you are joining
Alias		Alias of the table used in the query
Join condition		Condition used to join this table in to the query. Use the right hand mouse button (RMB) in order to get a context menu with suggestions for the join condition.

Buttons

OK		Saves the information about the join
Cancel		Cancels this edit