csvjoin --left -c name data.csv emp-ids.csv

csvjoin merges two CSV files on a key column named by -c, here name, like a SQL JOIN. The --left flag keeps every row of the first file even when no match exists in the second, filling missing columns with blanks. Without --left only matching rows survive. This is the go-to command for enriching a dataset with a lookup table.