OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Joining

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Joining [message #640472]

Wed, 29 July 2015 02:58

Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi

Member

Dear Experts!
My Code is
***************
UPDATE PAS_POLBENEFPAYMENT X
SET X.PBP_PAYEE =

(SELECT SSC.CUST_FULLNAME
FROM PAS_POLUNDERWRITER PPU, SET_CUSTOMER SSC
WHERE PPU.CUST_CODE = SSC.CUST_CODE
AND PPU.CUST_LIFE = SSC.CUST_LIFE)
*********
My Question is how can join X.PPB_PROPOSAL=PPU.PPB_PROPOSAL
And where i join this condition

Report message to a moderator

Re: Joining [message #640474 is a reply to message #640472]

Wed, 29 July 2015 03:00

Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi

Member

I HAVE PPB_PROPOSAL IN PAS_POLBENEFPAYMENT X AND PAS_POLUNDERWRITER PPU

Report message to a moderator

Re: Joining [message #640475 is a reply to message #640472]

Wed, 29 July 2015 03:13

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't you think it should better to show your table and their relation and explain what you are trying to achieve instead of saying you have spots and ask us how to remove them?

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Report message to a moderator

Re: Joining [message #640497 is a reply to message #640474]

Wed, 29 July 2015 09:40

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

And what's wrong with this?:

UPDATE Pas_Polbenefpayment X
   SET X.Pbp_Payee      =
          ( SELECT Ssc.Cust_Fullname
              FROM Pas_Polunderwriter Ppu, Set_Customer Ssc
             WHERE Ppu.Ppb_Proposal = X.Ppb_Proposal
               AND Ppu.Cust_Code = Ssc.Cust_Code
               AND Ppu.Cust_Life = Ssc.Cust_Life )
 WHERE --... Here you need something to limit the rows to update

Report message to a moderator

Previous Topic:	Max on Sum
Next Topic:	Need a query to get the ouput in an expected format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 29 18:19:59 CDT 2026