Have a report that makes the following innerjoins
Drive >People>TeamMemberDetail>TeamMaster

This allows me make the following connection.

Drive.recuriterID > People.PersonID>TeamMemberDetail.PersonID>
TeamMemberDetail.TeamID>TeamMasterTeam.ID

This allows me to match a sales person  to thier sales  team name (for grouping).  This is all working fine.

However, I have a marketing department this is actually setup like a person with no teammember or teamdetail reference.

So when I run the report the marketing department is left out. How can I also grab the marketing dept without any references in the last two tables?

Thanks again in advance.

Flanman