the main array
the lookup array
mainTable's column for the join condition
lookupTable's column for the join condition
defines which attributes we want to retain in the joined array; null values generated by the function are ignored
the joined array
Join two arrays by a common column, selecting which data to extract.