How do I query a M-M Relationship?

[rvancleef]

Assuming 3 tables:
Division (DivCode, DivName)
Department (DeptCode, DivCode, DeptName)
Professor (FName, LName, DeptCode)

How do I write a query to return a listing or professors by Division? So far I can only write queries that return Departments based on Division or Professors based on Department.

Is this a circumstance where Cursors are required?

Please return and code snippets or References to online articles that are clear for an SQL Server newbie.

Thanks!!!

 

[rvancleef]

Sorry to bother. I answered my own question.

Use an Inner Join:
SELECT facstaff.FirstName, facstaff.LastName , Department.DivisionCode, Department.DeptCode
FROM facstaff
INNER JOIN Department ON Department.DeptCode = facstaff.Dept
WHERE Department.DivisionCode = 'NS'
ORDER BY LastName,FirstName