Specify Partition name dynamically in Select Clause

[DaPi]

(Assuming an index can not be used) if you specify
WHERE join_date >= x
AND join_date < y
(x & y chosen appropriately) then only the relevant partion should be scanned.