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

amerar_at_iwc.net wrote in
news:1112285509.392298.320390_at_g14g2000cwa.googlegroups.com:

>
> This is also not working.....
>
> UPDATE A
> SET EID = (SELECT EID FROM B)
> WHERE (SELECT NBR FROM A WHERE STATUS = 'ABC') =
> (SELECT NBR FROM B WHERE AMT > 0);
>

UPDATE T1 SET EID = (SELECT EID FROM T2 WHERE T1.NBR = T2.NBR); Received on Fri Apr 01 2005 - 09:27:37 CST