Skip to Content
0
Former Member
Oct 07, 2011 at 03:08 PM

Subquery in Select Statement

2858 Views

Hi,

In crystal reports 10 is there a way to alter the select statement to include a subquery into the select statement. For example

select customer.lastname from customer;

to be

select customer.lastname , (select departmentname from dept where customer.dept_id= dept.dept_id) as "Customer_DeptName"

from customer;

I don't know how to do this in crystal but this can easily be done in toad or other sql query tool.

Please advise.

Thanks.

Tom.