can I do this in CR10?

Post Author: avilo

CA Forum: Data Connectivity and SQL

I want to do this query in DB2

select * FROM T AS T2, T1 WHERE T2.NOMINA = T1.NOMINA AND (('31.12.2006' BETWEEN T2.FEINI AND T2.FEFIN) OR (T1.COD_SIT = ' ' AND T2.FEFIN IN (SELECT MAX(FEFIN) FROM T WHERE NOMINA = T1.NOMINA))) how can i do the subquery SELECT MAX(FEFIN) FROM T WHERE NOMINA = T1.NOMINA) in the crystal reports 10?