```
SELECT FirstName
FROM Adjuncts 
INNER JOIN Faculty ON Adjuncts.FirstName = Faculty.FirstName  

```

This is my Microsoft SQL Server 2012 code. I am trying to join two tables together (`Adjuncts` and `Faculty`) and share their `FirstName`, and `LastName` columns. I tried to just do one (`FirstName`) to see if I could make it work, and could not. I was receiving the following error message: 

> 
> Msg 209, Level 16, State 1, Line 1  
> 
>  Ambiguous column name 'FirstName'
> 
> 
> 

Is anyone able to tell me how to properly join the two tables together? And how to show ONLY the 'FirstName' & 'LastName' columns which are defined in each of the tables **WITHOUT** overlapping the 'FirstName' & 'LastName' columns and having them twice.