Occasional T-SQL assistance

I'm finding myself using T-SQL more and more, without the necessary skills or training.

I'm fine with basic stuff, but get frustrated at what *should* be a fairly simple query not working as expected.

So.. I'm looking for a mentor.. someone who I can email very occasionally with a query and who can not only help with the specific code but - as importantly ! - explain where I was going wrong and why.

My current issue is posted below (which I know is wrong !). I'm not looking for a free answer - I've posted this to give respondents an idea of level required.

I'm looking to select all records that match in two tables, and insert the value of one field into the other table.

Select LocationTracking.Location,Users.Code, Users.LocationControl, Users.NNorDF

from LocationTracking
INNER JOIN Users ON Users.LocationControl = LocationTracking.Location

(Insert into LocationTracking (LocationTracking.Site) Values(Users.NNorDF))