how to SQL expresion 1

[Durango122]

Hi all
cr 9.0
ms sql
I trying to get this query into an sql expression
-------------------------------------------------------
select distinct portfolio from funds where fund_group = '59' and CSTM_FundChannel = 'Age-B'
-------------------------------------------
can someone help plz

thanks


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[rhinok]

Generally speaking, you need to add parentheses around your SQL Expression, a la:

(
SELECT DISTINCT
portfolio
FROM
funds
WHERE
fund_group = '59'
AND CSTM_FundChannel = 'Age-B'
)

A SQL Expression field is essentially the same as a subquery in true SQL. You can choose to correlate the SQL Expression to your main query or not.

In this case, is CSTM_FundChannel a field in your main report? If so, I would erase the field, find it in the field tree and double-click it to reinsert it into the report. This will ensure that the field is referenced with the exact syntax.

~Kurt

http://www.acuityreporting.com