i have two table namely training_courses and employees_training_dtl.
in training _courses table i have all courses details like course no which is primery key ,trainercode1,trainercode2,trainercode1,trainercode4
in employees_training_dtl table i have course no which can be repeat to a no of time because same courses training can be provided to the no of employee and the between training dates in which training is running.
i have to make a report in oracle 6i for displaying trainerwise report between given dates of training .
If you want to know how your query should look alike, you have to provide the table-definitions with the relevant columns, a set of sample-data and the desired output. And you should ask this question in the SQL/PLSQL-forum.