Specify Partition name dynamically in Select Clause

[mmvraja]

Hi,

Say for example, the table is partioned based on Join Date.

1. How do i specify the partition name in WHERE clause dynamically

2. How do i specify the partition name in FROM clause dynamically

Iam not using PL/SQL(not required). I use only SQL.