added JOIN assignment.