create join purchases view