Home » SQL & PL/SQL » SQL & PL/SQL » help in sql (oracle 10g,win xp)
help in sql [message #326195] Tue, 10 June 2008 10:14 Go to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
Hi

I need to write a sql statement to fetch many values but i am stuck in the logic?
Can anyone help here!!!

Now i have a list of values which are all present in ac_contact_key of
ACE2_CONTACT table

But i need to fetch there values from all the tables matching with the contact lists i have

I need all these

This looks very complicated,i am unale to figure out

The list of values-all r present in ac_contact_key and are unique but in the telephone and address table they are repeated and among all the best contact is selected by MATCHING WITH AC_CONTACT_KEY IN Application but here we need this for those lists of contact values present in ac_contact_key???

the fileds--

also the contact keys of telephone and address table doen't have all the contacts that i have in the list of contacts as the ace2_contact table has???


please advice???


[EDITED by LF: as requested by the Original Poster, tables' descriptions have been removed]

[Updated on: Wed, 19 November 2008 05:28] by Moderator

Report message to a moderator

Re: help in sql [message #326200 is a reply to message #326195] Tue, 10 June 2008 11:02 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
Is anyone there?Kindly reply
Re: help in sql [message #326201 is a reply to message #326200] Tue, 10 June 2008 11:04 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
swas_fly wrote on Tue, 10 June 2008 09:02
Is anyone there?Kindly reply


http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above.

NOBODY owes you any response to a post that does not come close to meeting Posting Guidelines.
Re: help in sql [message #326202 is a reply to message #326201] Tue, 10 June 2008 11:40 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
apologise for the same.Was in hurry but i understand now.
Re: help in sql [message #326207 is a reply to message #326202] Tue, 10 June 2008 12:15 Go to previous messageGo to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
please let me know if i am clear in the requirement thank a lot
Re: help in sql [message #326370 is a reply to message #326207] Wed, 11 June 2008 04:48 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Your requirements are not clear.

Can you provide more detail about how you want to pick the records from tables 2,3,4
Previous Topic: Performance of execute immediate
Next Topic: SELECT THE DATA WITH ANY CASE
Goto Forum:
  


Current Time: Tue Dec 06 15:55:28 CST 2016

Total time taken to generate the page: 0.06455 seconds