[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Required Mysql query "Unable to design query" for common column entry on the basis of different another coloumn

Asked by umangtandon in MySQL Server, PHP and Databases

Tags: Mysql, Php

Hii,
First of all consider a sample table structure
a_party               b_party           duration      date                 time          cell_id            imei_no
9899452001    9899345651        13         20-05-2009         1300         18901        8888888888
9899452001    9818726390          5         20-05-2009         1500         24313        8888888888
9736071044    9899345651          9         20-05-2009         2300         16235        5555555555
9818726390    9899452001         25        21-05-2009         0900         32654        7777777777
9865385488    9899345651          9         21-05-2009         0930         18901        1234567890
9818726390    9899452001         20        21-05-2009         1000         24313        7777777777
9345873270    9899345651          5         21-05-2009         1200         24313        4567893210

question:
I have to find common "b_party",on the basis of distinct cell_id

for eg. common b_party is"9899345651" and "9899452001" from distinct cell_id
Please help.....can anybody could write query for the same.
[+][-]10/23/09 04:23 PM, ID: 25649728Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/23/09 11:24 PM, ID: 25651051Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/23/09 11:41 PM, ID: 25651085Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/24/09 12:10 AM, ID: 25651140Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10/24/09 04:27 AM, ID: 25651670Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/30/09 12:50 AM, ID: 25700796Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625