How lookup a value for TSQL Query.

I am building a query in MSAccess 2013. I have a Table containing the names of documents, and a different Table containing the path these Documents reside in. I would like a query that concatenates the path with the name of the document. Perhaps something like

SELECT Documents.ID, (SELECT Val FROM Local_Config WHERE Key = 'Repo') & Documents.Name From Documents;

Select all Open in new window

I think this is a basic SQL question that I just don't have the knowledge to answer.