The join prefix joins the loaded table with an existing named table or the last previously created logical table. The join is a natural join made over all the common fields. The join statement may be preceded by one of the prefixes inner, outer, left or right.
