Prev: Time difference between multiple times and dates
Next: SQL Statement
From: Nuno Gomes on 30 Jun 2008 04:51
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


From: KARL DEWEY on 30 Jun 2008 10:35
>>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.
--
KARL DEWEY
Build a little - Test a little


"Nuno Gomes" wrote:

> 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
>
>
>
 | 
Pages: 1
Prev: Time difference between multiple times and dates
Next: SQL Statement