Re: Update with Join Question......

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Thu, 31 Mar 2005 15:47:55 GMT
Message-ID: <Xns962A4F54F85B7SunnySD@68.6.19.6>

amerar_at_iwc.net wrote in
news:1112283239.764482.109270_at_o13g2000cwo.googlegroups.com:

>
> Hi All,
>
> Here is an update I am having problems getting to work:
>
> I have 2 tables:
>
> T1
> EID
> NBR
> STATUS
>
> T2
> EID
> NBR
> AMT
>
> In T1, a combination of NBR & STATUS = 'ABC' makes NBR unique. So, for
> each STATUS = 'ABC' there is only 1 NBR.
>
> In T2, a combination of NBR & AMT > 0 makes NBR unique. So, for each
> AMT > 0 there is only 1 NBR.
>
> I want to update EID in T1 with the EID in T2 where T1.NBR = T2.NBR

So what is stopping you from doing so?

What have you tried so far? Received on Thu Mar 31 2005 - 09:47:55 CST