join with pig.