Hello!
I have a straight-forward query that I can't figure out how to convert to generated code.
Can anyone point me in the right direction?
This is the query:
SELECT
Sum(P.Price * C.Quantity)
FROM
Certificate C
INNER JOIN
FundProduct P ON P.FundProductID = C.FundProductID
WHERE
C.CertificateStatusID = 1
AND
C.FundID = 21
Thanks,
!Rob