Keep and Join do the same functions, but keep creates two tables whereas join merges two tables to create one table. Keep is used before the load or select statement.