hi there,

I need help. I have 1 database, many tables.

here the situation:
I have 1 table which contain field_a,field_b,field_c,field_d --> table_1
I have 1 table which contain field_c,field_d, field_e --> table_2
in table_1, it is possible to have same record more than one in the field_c
in table_2, it is not allowed to have same record more than one in the field_c

what I need is:
I need to fill field_d in table_1 based on record in field_d on table_2, when field_c same each other (between table_1 and table_2).

I need to generate the code that can work like that.

I use MS SQL server to create database.

need help, please advice how to generate the code like that. thanks before