SQL problem

[WP]

In my Oracle database I have two tables

Table A Table B
EXCHANGE <------------> EXCHANGE
ISIN<----------------------> ISIN
SEDOL<-------------------> SEDOL
RISK RISK
etc. etc.

which share EXCHANGE,ISIN and SEDOL as there key and are matched 1 to 1.

How do I update table A RISK with table B RISK ?


Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[MikeJones]

update tablea
set risk = (select risk from table b where tableb.exchange = tablea.exchange and tableb.isin = tablea.isin and tableb.sedol = tablea.sedol)

 

[manj]

If your tables are exactly the same you could try:

insert into table A
select * from table B;

 

[MikeJones]

I'd not read your question properly, why do you appear to have two identical tables?

 

[WP]

They are not the same and I have just found that there is a one to many relationship from A to B. The two tables are not the same the only fields that are the same are those I listed.

We have an extract that currently loads into A. A new table B is going to replace it. Until the code is written for the new extract I need a workaround.

I need to have a SP that reads A and updates B. Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[MikeJones]

My last posting should do it (Just revese the table ref as the orig copies from B to A. Performance could be a problem though if there are many rows.

As 1 row in A relates to many rows in B you will be updating several rows in B with 1 row of info from A. Is this what you want?