The join pig scripts