Question: what is the difference between lookup and join in sap bods?
Answer: Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select the most relevant row in the case of multiple matches).