in and where clause

[mp3909]

Hi All,

How do I replicate this sql logic in my cognos report?

sql clause --> and a.customerNumber in (select c.customerNumber from c where c.accountNumber=4) ???

I tried adding this in the detail filters of the query:

[a].[customerNumber] in ([c].[customerNumber]) where [c].[accountNumber]=4 but it's complaining.


Any ideas?

Thanks

[Wangd]

You will need to use SQL for the Query. 
See this: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_wrkdat_build_report_using_your_own_sql_mdx.html

[dougp]

How is that different from...

Code Select Expand

from a
  inner join c on c.customerNumber = a.customerNumber
              and c.accountNumber = 4
...?

Create two queries and join them.