Help selecting rows based on values in other rows.

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

G.R.Prithiviraj Kulasingham SSCarpal Tunnel Points: 4105 More actions · Answer 1

In the way I understood your problem, I believe that your result sould be some thing else.

("..I only want the 6 PENDING rows where..")

Do you say the call_ID should have 6 PENDING and either 3 3RD RESPONDED or 7 3RD RESOLVED

The way I unsterstand the problem this is the answer.

Select Distinct A.Call_ID, A.Call_Status From (select * from Call_Master Where Call_Status ='6 PENDING') A,

(select * from Call_Master Where Call_Status in ('3 3RD RESPONDED', '7 3RD RESOLVED')) B

Where A.Call_ID = B.Call_ID

If the problem is different explain me more.

Cheers,
Prithiviraj Kulasingham

http://preethiviraj.blogspot.com/

chris_rutherford Mr or Mrs. 500 Points: 590 More actions · Answer 2

Thanks to Preethi this job is now complete. I modified the code slightly to read the following...

Select Distinct A.Call_ID,

A.Customer_name,

A.Call_Status_Value

From (select * from status_tracking Where Call_Status_Value in ('3 3RD RESPONDED', '7 3RD RESOLVED','6 PENDING')) a,

(select * from status_tracking Where Call_Status_Value in ('3 3RD RESPONDED', '7 3RD RESOLVED')) B

Where A.Call_ID = B.Call_ID

order by a.call_id asc

Thanks again.

Chris

Steve Jones - SSC Editor SSC Guru Points: 736352 More actions · Answer 3

Thanks for posting and glad that it worked for you.

Steve Jones