Condition in joins

Jan 24 2014 9:32 AM

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