Question: what is the difference between join and relate in arcgis?
Answer: A table join appends all the columns from one table into the other table based on the unique ID. But a table relate creates an entirely new table. So when you select record(s) in one table, it will create a temporary table based on all the matching unique IDs.