Home » SQL & PL/SQL » SQL & PL/SQL » sub Query
sub Query [message #1472] Sat, 04 May 2002 00:22 Go to next message
N. Rammohan
Messages: 5
Registered: May 2002
Junior Member
Hi guys pl help me in solving the problem.
I have two tables

table 1 (TRANSACTION).... table 2(MASTER)

trantype varchar2(2)..... wono number(5)
wono number(5).......... woqty number(5)
woqty number(5)..........

there are morethan two rows in table1 for wono.
i want to update the woqty in table1 for only
one row for each wono from table 2.
pl help me.

Report message to a moderator

Re: sub Query [message #1474 is a reply to message #1472] Sat, 04 May 2002 11:01 Go to previous message
Raj
Messages: 411
Registered: November 1998
Senior Member
Use the primary key of table 1

Report message to a moderator

Previous Topic: reducing size of a database
Next Topic: INSERT INTO IN ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 12:12:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.