Using more columns of data across comparable row patterns, joins combine tables. If tables are at various levels of detail, this might result in data loss or duplication, and joins must be created before analysis can start. A published data source cannot be used in a join.