Query Relationship help

[rhaas128]

So I've got 4 tables:

Servers
Approvers
Reviewers
Groups

I have laid samples out of each table below. What I am trying to achieve is to look at a list of all the servers, and if they have an approver, list the approver. Also, if an entry from the servers table matches a server in the reviewers table, to list the reviewer & their email. And if a reviewer exists, check for a match on the groups table (the reviewer could be a person or a group). And if a match is found, provide the email from the groups table. Server3 exists with no approver or reviewer.

Servers Table:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Server[/TD]
[/TR]
[TR]
[TD]Server1
[/TD]
[/TR]
[TR]
[TD]Server2[/TD]
[/TR]
[TR]
[TD]Server3[/TD]
[/TR]
</tbody>[/TABLE]

Approvers Table
[TABLE="width: 500"]
<tbody>[TR]
[TD]Server[/TD]
[TD]Approver[/TD]
[/TR]
[TR]
[TD]Server1[/TD]
[TD]User1[/TD]
[/TR]
[TR]
[TD]Server2[/TD]
[TD]User2[/TD]
[/TR]
[TR]
[TD]Server1[/TD]
[TD]User2[/TD]
[/TR]
</tbody>[/TABLE]

Reviewers Table
[TABLE="width: 500"]
<tbody>[TR]
[TD]Server[/TD]
[TD]Reviewer[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD]Server1[/TD]
[TD]Group1[/TD]
[TD]group1@email[/TD]
[/TR]
[TR]
[TD]Server2[/TD]
[TD]Reviewer1[/TD]
[TD]reviewer1@email[/TD]
[/TR]
</tbody>[/TABLE]

Groups Table
[TABLE="width: 500"]
<tbody>[TR]
[TD]Group[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD]Group1[/TD]
[TD]group1@email[/TD]
[/TR]
[TR]
[TD]Group2[/TD]
[TD]group2@email[/TD]
[/TR]
</tbody>[/TABLE]




RESULTS TABLE
[TABLE="width: 500"]
<tbody>[TR]
[TD]Server[/TD]
[TD]Approver[/TD]
[TD]Reviewer[/TD]
[TD]ReviewerEmail[/TD]
[TD]GroupEmail[/TD]
[/TR]
[TR]
[TD]Server1[/TD]
[TD]User1[/TD]
[TD]Group1[/TD]
[TD]group1@email[/TD]
[TD]group1@email[/TD]
[/TR]
[TR]
[TD]Server1[/TD]
[TD]User2[/TD]
[TD]Group1[/TD]
[TD]group1@email[/TD]
[TD]group1@email[/TD]
[/TR]
[TR]
[TD]Server2[/TD]
[TD]User2[/TD]
[TD]Reviewer1[/TD]
[TD]reviewer1@email[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Server3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Any and all help is greatly appreciated.