Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Update records in table

Re: Update records in table

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 10 Jan 2005 20:13:42 +0100
Message-ID: <41e2d3e2$0$19604$636a15ce@news.free.fr> 






"yey2000" <yey2000_at_gmail.com> a écrit dans le message de
news:1105382104.821805.168520_at_f14g2000cwb.googlegroups.com...


| 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://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_108a.htm#2068178



Regards


Michel Cadot
Received on Mon Jan 10 2005 - 13:13:42 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US