TSQL INNER JOIN
===

I'm building an IT support ticketing portal for a multi-site company.
I cant get my head around JOIN, INNER JOIN, ON , etc.

I have 3 tables:

Firstly [Support_Ticket] containing [Site_ID], which I already have from a previous query. 

So I have the Site_ID, and need to get the name (string) of the engineer that is responsible for support on that site. Lets say Hull is Site_ID:1.

The other 2 tables :
[Site_Details] containing (among others) [Site_ID] and [Site_Default_Engineer_ID]
and
[Engineers] containing (among others) [Engineer_ID] and [Engineer_Display_Name]



What I want to achieve is (pseudo-code!):
return [Engineers].[Engineer_Display_Name] 
where [Engineers].[Engineer_ID] = [Site_Details].[Site_Default_Engineer_ID]
(but first)
return [Site_Details].[Site_Default_Engineer_ID]
where [Site_Details].[Site_ID] = [Support_Ticket].[Site_ID]


if that makes sense?!