Condition in joins

Question

Hi,

   In one SP, if same table need to perform as left join and inner join to another table based on some condition..

If possible ...Please let me know ...  


Thanks in advance
Sathish