Update A Field With Count (*)

Hi,





I am trying to update a field in a temptable with the count of items in another table. To illustrate, CustomerID=23 and I want the number of occurences in the temp table. Here's the code which DOESN'T work:








INSERT INTO TempTable


(


CustomerID,


FirstName,


LastName,


DateAdded,


AlbumPicture,


LayoutCount


)


SELECT


Albums.CustomerID,


Customers.FirstName,


Customers.LastName,


DateAdded,


AlbumPicture,


COUNT(*) FROM Layouts WHERE Layout.customerID = Albums.CustomerID


FROM


Albums JOIN


Customers on (Albums.CustomerID=Customers.CustomerID)








Please take a look at the COUNT line. Here I want to count the occurences of a specific customerid in another table and put in into th LayoutCount field.





SQL server reports "Incorrect syntax near the keyword 'FROM'". Any ideas how to achieve this?





Many thanks!!





Eric