Avatar of jasmeen kaur
jasmeen kaur

asked on 

Query Syntax

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


Avatar of undefined
Last Comment
Pawan Kumar

8/22/2022 - Mon