In Query, a line that connects fields between two tables and shows how the data is related. The type of join indicates which records are selected for the query's result set.