Does 9.0 Support Subqueries?

[peggys]

Does anyone know if Crystal 9.0 supports subqueries or union queries? I realize that I can write a stored procedure to accomplish this, but I need to know if 9.0 supports this from the Crystal development screen? Can I pull in more than one query and join them to extract data?

Thanks!
Peggy

 

[synapsevampire]

CR 9 supports subqueries and Unions.

CR 8.5 supported Unions.

-k

 

[peggys]

Do I have to use SQL to accomplish this? or can I do this directly in the Visual Linking Expert?

Peggy

 

[chelseatech]

CR9 has a "Database Expert" that combines the "Find Database" and "Visual Linking" screens. One of the data sources from a data connection is a SQL command where you can do UNION and Sub-SELECT's.

You can also do Inserts, Updates and Deletes, and have multiple SQL statements, but the last thing has to be a SQL SELECT of some sort. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[synapsevampire]

You'd need to write SQL for a subquery.

-k

 

[peggys]

Thanks for the info! That's what I needed to know.

Peg