SQL Error:An aggregate may not appear in the set list of an UPDATE statement.

原来sql语句： 
 update [dbo].[TableA]
  set ColumnA=Count(*)
  from [dbo].[TableB]
改后：
 update [dbo].[TableA]
  set ColumnA=tmpTable.ColumnB
  from(
    select Count(*) as ColumnB
    from [dbo].[TableB]
  )tmpTable