In Query, a join where all records from one table are selected, even if there are no matching records in another table. Records that match are combined and shown as one. Records that don't have matches in the other table are shown empty.