Added join logic to select object.