inserting from another table

greeetings all. i'm new to access as i'm more of an excel person. anyways i'm using an existing access database from a co-worker where i want to add a table into the main table that is pulling data from 1 other table.

here's the SQL command:
SELECT dd.SMT AS TBM, dd.[Cust Name] AS DealerName, dd.City, dd.State, d.Dealer, d.Product,
d.PIN, d.Description, d.SpendingPeriod, CCUR(IIF(d.Earned='-',0,nz(d.Earned,0))) AS Earned, CCUR(IIF(d.Spent='-',0,nz(d.Spent,0))) AS Spent, CCUR(nz(d.Balance,0)) AS Balance, d.Models, ddd.MaxSpend
INTO tblMainReport

FROM qry_Detail AS d

INNER JOIN tblDlrDump_F0101 AS dd ON d.Dealer = dd.Dealer;

i'm trying to add a column called "MaxSpend" from a table called tblPrgram and insert it with the other data into tblMainReport (i created a column for MaxSpend). I'm not certain where to and if to add another SELECT command line or add it into the command line with the others?

thanks for your help!

use an append query to add data from a table/query
(use the query wizard)

also:
use an update to change existing data in a table
use a delete query to remove records from a table