My columns in the table is defined as below
fund1 fund2 pricingdatefund1 pricingdatefund2
I have to fetch the records in a way that if pricing date fund 1= 15 Nov then fetch fund 1 record , if pricing date fund 2= 15 Nov then fetch fund2 record and if both of the pricingdatefund1, pricingdatefund2 matches my date then fetch both fund 1 and fund2.
I know it is complicated. I hope I have explained it