I want to create a calculated field using 2 fields which are in different tables. I have left joined table2 to table1 and then created a resident table to create the needed calculated field.
Is there any other way to create it. I mean can i create the calculated field in table1 directly?
