A specified series of operations, called steps, performed sequentially by a SQL Server agent.
join
The act of combining the data in two tables based on values found in each of the tables.