Skip to Content
0
Former Member
May 02, 2014 at 08:38 PM

Trouble with commands

22 Views

I use Crystal Reports XI R2. I'm attempting to create a command that contains a subquery and I keep getting the same error. Here's a simplified version of the query:

select

ls.leadid

from (select leadid

from lead) ls

This query results in the following error. Is there some special syntax I need to use for subqueries?

Thank you!

Attachments

command error.jpg (33.9 kB)