calculate field

Question

is there a way to calculate a field in a table from data in another table in SQL database?

the case is I have two tables in a database both have the same IDs, so I want to fill a column in one table from the a column in the other table.

i tried to write a code but it did not work as I'm still a beginner in coding.

if Charts_Limits['SURVEY_ID_REF'] == Survey_Limit_Polygon['SURVEY_ID_REF']:

Charts_Limits['Survey_Type_Updated'].append(Survey_Limit_Polygon['Survey_Type_Updated'])

RobertBorchert · Answer

Can you put the two features into a relationship? This SQL code works in a definition query for features in a relationship. Table1 Table2 Table2 Table2 ORIGINFIELD IN (SELECT DESTINATIONFIELD FROM where ) I use it to show only points in a Dashboard that have an attachment associated with it. It may work with a SQL query for Labels.

danretired · Answer

Temporarily join the tables and calculate your field in the target table using the field in the join table.  When done, remove the join.

As a note, if you are trying to update values in the target table, you can always make a query/selection prior to doing the calculation.  Field calculations are only done on selected records