9/8/2023 0 Comments Avg will not updateTo reiterate all I'm trying to do is get the average of the Avg RSSI column in Table1 for each distinct MIU ID and insert each value into the appropriate row in Table2. ![]() SET Table2.MeanNum = Avg(.) Īnd the other query I've tried is: UPDATE Table2 I have tried the following and variations of the following and the errors I'm getting are that it won't let me use Group By, and another error saying that MeanNum is not part of the aggregate function. However I need this information to be inserted into a column in Table2. If I were simply using a select statement I would do the following: Select DISTINCT Table1., Avg(Table1.) as MeanNum ![]() ![]() The relevant tables and column information are as follows: I am trying to get the average for each MIUID inserted into a table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |