help with a query

  • Thread starter Thread starter Nuno Gomes
  • Start date Start date
N

Nuno Gomes

Hello all,

I have table Customer with the field CP
I have the table Cpostal with the field CP_NUM

The relation between this two tables is Customer.CP 1->N Cpostal.CP_NUM
This means that the for one CP code in the table Customer i have N CP_NUM in
the table Cpostal.

My goal is update the field CP with the first ocorrence of CP_NUM.

How can i do this?...



Thank's in advance,


Nuno Gomes
 
My goal is update the field CP with the first ocorrence of CP_NUM
Based upon the information you presented it can not be done.

You say that CP is related to CP_NUM in a one to many. If they are related
then there is nothing to update as they are the same from the start.

Maybe you meant something else.
 
Back
Top