[Category].Category AS project_type,
[SalesManager].SalesManager As Manager
INNER JOIN [Category] ON
[Category].ID = Projects.Category
INNER JOIN [MO/FSC] ON
Projects.ProjectID = [MO/FSC].Project
INNER JOIN [SalesManager] ON
[SalesManager].ID = Projects.SalesManagerID
You can even leave out the JOIN with [MO/FSC].
Last edited by Wim; 04-05-12 at 21:01.
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2. Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages