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.