You need to sign in to do that
Don't have an account?
jlim
Question: SOQL how to join Opportunity Close Date with Dated Conversion Rate?
I would like to accomplish this in 1 query. Is it possible? When selecting the Opportunity, I have the CloseDate and I would like to use this CloseDate and lookup in the DatedConversionRate table and get the exchange rate.
Thanks.
SOQL does not support all advanced features of the SQL SELECT command. For example, you cannot use
SOQL to perform arbitrary join operations, use wildcards in feld lists, or use calculation expressions.