Re: Help Help Help Help Help Help Help Help Help Help Help Paleeeeeezzzzzzz!!!!!!!!

dear "RogerRabbit":
I missed your original note, but try this: update pm
set pm1 =
(select meterreading
 from equipment
 where meterreading.eqnum = pm.eqnum)
/

The Nephilim wrote:
>
> I am a novice to Oracle, but I know SQL fairly well, and I think you can
> do your update with an "update query". I've used them often in Access,
> and I believe it is ANSI compliant, so Oracle should have the command.
> Look it up. It would be vastly quicker than using code.
>
> Dave Bicking
>
> In article <329b314c.11287833_at_news.primenet.com>,
> RogerRabbit_at_TuneTownUSA.com wrote:
> >I have a problem that I need to solve at work, and thinking that
> >there is a good chance that someone in this conference/news group
> >would know how to tackle it, I decided to give this avenue a try...
> >
> >Here it is;
> >1. I need to update a table with information from another table.
> >2. These two tables are 'linked' by their equipment number (eqnum).
> >3. Table names are PM and EQUIPMENT.
> >4. The two rows (fields) are of the same type/size and match.
> >5. The row to update is from the PM table and is called PM1
> > (NUM 15.2 NOT NULL)
> >6. The row the information is from the EQUIPMENT table and is
> > called METERREADING (NUM 15.2 NOT NULL)
>
> --
> Come visit our humble keep at:
> http://www.netaxis.com/nephilim/
> You'll find many very interesting links! Let us know if you like our pages.
Received on Mon Dec 02 1996 - 00:00:00 CET