complex join example
changes in split procedure