Oracle SQL converted into Crystal Syntax

[mh53jfe]

I have a report that I am calling the class roster sign in sheet. The class roster includes the class number and name, student name, and other information. Additionally, my customer wants to place the instructor's name on the report. That is where I am having my problem. I have tried everything I can think of in Crystal to show the instructor's name all to no avail. I went into SQL Worksheet and wrote a query that works. I would like to convert the SQL script into crystal syntax and use it in a formula. ANy help will be highly appreciated. THanks in advance.

SELECT lname, employee_id, project_id
FROM TPV_PUB_EMPLOYEES, TPV_PUB_EMPLOYEE_ASSIGN, TPV_PUB_BASE_CLASSES
WHERE TPV_PUB_EMPLOYEE_ASSIGN.EMPLOYEE_ID = TPV_PUB_EMPLOYEES.ID AND
tpv_pub_base_classes.id = tpv_pub_employee_assign.project_id AND tpv_pub_base_classes.class_no = 001081; (In Crystal, I will substitue the class number with the parameter: {?class_number}.

 

[MalcolmW]

Why not just add those three tables to your main report, linking to the existing tables on class_no? Why does this have to be another SQL statement? Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?