Joins combine data from multiple Sheets based on matching columns, so you can see related information side by side in one dataset.
View this page on OrcaSheets