$select->join( '#TCPLANGTABLE', new Expression('#TCPLANGTABLE.#TCPLANGTBLFK = #TCPPRIMARYTABLE.#TCPPRIMARYTBLPK AND #TCPLANGTBLLANGFK ='.$langId.''), ['*'], $select::JOIN_LEFT );
info at phpclasses dot org