Populate Table with query results

[sparkyboy2406]

Hi Guys,




I have a master table and a calls table.

I have a field in the master table that i would like to update with the results of the following query

SELECT calls.guid, master.Name AS customer, Count(calls.guid) AS NoOfCalls
FROM master LEFT JOIN calls ON master.GUID = calls.guid
GROUP BY calls.guid, master.Name;

I need to use an update statement

but how do i get TimesCustCalled field in the master table populated with the results of the query above using an update statement?

i have attached my sample database

Any help is greatly appreciated

Thanks

[NassauBob]

Well, is there ONE field from the query you would populate the ONE field in the master table with? Because I know you cannot put the results of any query into another table unless the fields you intend to populate are matched in number and type by the query results.

In other words, an update query needs to return the same number of attributes (columns) that you intend to update in the table.