I'm trying to run a script that will update an integer field in one table from a count in another table.
Right now, I have:
SELECT COUNT(*) AS numreg FROM REGISTRATION
WHERE REGISTRATION.COURSE_OFFERING_ID =
AND REGISTRATION.DELETED_IND = 'N'
This grabs the count of each REGID associated with a CO_ID.
List is something like:
I have a blank field in another table called NUM_REG.
I want to just insert the fields from the COUNT(*) into NUM_REG.
ASP.NET 1.1 Developer