Hi handkot,

thanks for your reply. The query is working fine.

Thanks & Regards,

Sudheendra

Hi Kingston Dhasian,

thanks for replying.

You didn't understood my problem. I need to join both Product Table and the ProductDescriptor Table through ProductDescriptorMapping table to get only those records whose DescriptorValueId...