can I do this in CR10?

[Former Member]

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?

[Former Member]

Post Author: V361

CA Forum: Data Connectivity and SQL

I can't explain in Spanish, but here goes. Try database, database expert, depending on your conneciton, you should have an option to add command. I tried to paste a picture, but this format will not allow that.

[Former Member]

Post Author: avilo

CA Forum: Data Connectivity and SQL

Thanks for the suggestion but I'm beginning with CR10. I don't know what is the command object, nor in which menu is. In addition I have the version in Spanish and don't know what it corresponds in English.

Can somebody explain me the command?

Thank you

[Former Member]

Post Author: quafto

CA Forum: Data Connectivity and SQL

You could use a command object.