Three table JOINed

I need information from three tables: This is an example
Students,Teachers , subjects.
I need a report which tells

1. subject (from subjects) - How many Students (m, F, M+F) - Which Teacher. (Fees subjectwise from subject)

How do i dot that in asp and if possible not through CR.?

What part are you having trouble with? Retrieving the results of the JOINed tables or using it in a report?