I am trying to update a access table with data from this table. Specifically the account.
UPDATE PRODUCTO P, HISTORICO H SET V1= count(menaje) WHERE P.codigo=H.codigo;
The thing is, it gives me an error that it does not include V1 as part of an aggregate function. I know that this is solved by putting the GROUP BY but I am unable to find where.
If I remove the
count(menaje) and leave it as household works well.