J
job
A specified series of operations, called steps, performed sequentially by SQL Server Agent.
join
As a verb, to combine the contents of two or more tables and produce a result set that incorporates rows and columns from each table. Tables are typically joined by using data that they have in common. As a noun, join refers to the process or result of joining tables (as in the term inner join) to indicate a particular method of joining tables. See also join column.
join column
A column referenced in a join condition. See also join.
join condition
A comparison clause that specifies how tables are related by their join columns.
join field
See join column.
join filter
A row filter used in merge replication that defines a relationship between two tables that will be enforced during synchronization, which is similar to specifying a join between two tables.
join operator
A comparison operator in a join condition that determines how the two sides of the condition are evaluated and which rows are returned.
join path
A series of joins indicating how two tables are related.
join table
See junction table.
junction table
A table that establishes a relationship between other tables. The junction table contains foreign keys referencing the tables that form the relationship.