Home » SQL & PL/SQL » SQL & PL/SQL » need help urgent
icon4.gif  need help urgent [message #258444] Sat, 11 August 2007 23:55 Go to next message
vasanthkgm
Messages: 2
Registered: August 2007
Location: chicago
Junior Member

Hi
I want to mismatching values from the following query.
I think my query is incorrect.
can anyone rectify this. It will be a great help for me.

select ps.producer_org_nbr from
policy_search ps,
producer_search ps1
where ps.producer_org_nbr <> ps1.prodcer_org_nbr
and
ps.customer_org_nbr in
(select ps.customer_org_nbr
from policy_search ps,customer_search cs
where ps.customer_org_nbr<> cs.customer_org_nbr
and
ps.aggrement_nbr in
(select ps.agreement_nbr from policy_search ps,source src
where src.table_nbr=ps.agreement_nbr
and
src.sourcesystem_id in
(select src.sourcesytem_id from synch_transactions_results str1,source src
where str1.source_system_id =src.source_system_id
and str1.updated_dt>to_date('09-aug-07'))))

Basicaly I want only the producer org number should be mismatch
values based on the above condition.
Re: need help urgent [message #258445 is a reply to message #258444] Sun, 12 August 2007 00:00 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Please explain why it is URGENT for ME to solve this problem for you!

No Operating System name or version.
No Oracle version to 4 decimal places.
No code formatting (see http://www.orafaq.com/forum/t/59964/74940/)
No DDL.
No error message.
No help. [You're On Your Own (YOYO)!]



Re: need help urgent [message #258449 is a reply to message #258445] Sun, 12 August 2007 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And I add: silly and useless title.

"urgent" in the title is a good way to shut me up.
Regards
Michel
icon4.gif  Any Idea about this [message #258488 is a reply to message #258445] Sun, 12 August 2007 13:11 Go to previous messageGo to next message
vasanthkgm
Messages: 2
Registered: August 2007
Location: chicago
Junior Member

This is oracle version 8.
I want the mismatched producer org number based on the
condition.
Re: Any Idea about this [message #258489 is a reply to message #258488] Sun, 12 August 2007 13:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And I want you to format.

Regards
Michel
Re: need help urgent [message #258490 is a reply to message #258444] Sun, 12 August 2007 13:50 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
vasanthkgm,
are you aware, that without providing
- formatted table structure + sample data
- expected result (formatted) with exact explanation in words
- plus your formatted query (and its result)
you will not get very useful answers.

Maybe you could have a look at Question on duplicates thread. It seems to be similar to your question.
Previous Topic: triggers and packages
Next Topic: extracting data from the field
Goto Forum:
  


Current Time: Tue Dec 06 06:11:09 CST 2016

Total time taken to generate the page: 0.07163 seconds