Hi,

I have two tables in SQL namely Orders and Orderdtls. They are related by the field ctrlno I(4). Each table has a similar field named Trantype. The problem is, the value in Orders.Trantype column are accurate which I want to assign each corresponding value to the related record in the Orderdtls.Trantype.

Is there a way in sql query analyzer to do this job?

Thanks.....