Re: Update records in table

yey2000 wrote:

> I have to run an SQL to update records in a tableA
>
> The SQL will look like this:
>
> UPDATE TableA set POST_ID = TableB.DIVISION_ID
> where TableA.CREATED_BY = TableC.Id and TableC.POSITION = TableB.Id
>
> But I get an error saying "Invalid identifier".
> Any idea how to fix this SQL.
>
> Thanks a lot
>
> Regards
> Yi

http://www.psoug.org
click on Morgan's Library
click on Update Statements

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---