nest a join on a field not displayed into this query with a group by
<p>Current Query:</p>

<pre><code>Select Name, Charge_code, Charge, Max(Mod)Mod, Max(date)Date
From Table1
Where Name is not Null and Name &lt;&gt;'' and Charge is not Null and charge_code is not null
Group by Name, Charge_Code, Charge
</code></pre>

<p>In this same table1 I also have a Name identifier Number titled "IDNum" and in a separate table (table2) I also have that same Identifier number "IDNum" with a LocationID in a separate Column in table 2. In table 3 I have that location ID attached to an actual location name "location_Name". This is what I would like to have joined on to my data set.</p>

<p>Ultimately I'm wanting to return the following Results:</p>

<p>Name | Location | Charge Code | Charge | Mod | Date</p>

<p>How can I Nest a join into my existing query to pull back the Location Name based on that Identifier Number but not have the identifier number displayed in the results? sorry if this is a easy question I am new. 
Thanks</p>

<p>tried this to no avail:</p>

<pre><code>Select Name, Charge_code, Charge, Max(Mod)Mod, Max(date)Date, Location_Name
 From Table1
Join Location table1.IDNum = Table2.IDNum = Table3.Location_Name
Where Name is not Null and Name &lt;&gt;'' and Charge is not Null and charge_code is not null
Group by Name, Charge_Code, Charge
</code></pre>