help in sql [message #326195] |
Tue, 10 June 2008 10:14  |
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 #326370 is a reply to message #326207] |
Wed, 11 June 2008 04:48  |
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
|
|
|