Getting result where field type is same w/ other rows

slick101

hey everyone I have a table setup:

user_id|leader_id
5 20
3 20
1 9
92 20

I was wondering if there is a way to get results w/ out doing a where leader_id = 20 depending on the user_id

so i want to get the 3 results
5 20
3 20
92 20

SELECT * FROM table WHERE ?

thanks for your time!

paulnaj

Hi slick,

Er - bit confusing - the results all have leader_id = 20, so surely WHERE clause should just be ...

WHERE `leader_id` = 20

Doesn't seem to be any dependence on user_id

Paul

slick101

Yea I guess i was just trying to avoid doing 2 queries. wanted see if it can be done with just 1.

Thanks

Bjom

What are you talking about, please? Where is the second query?

SELECT userID, leaderID FROM myTable WHERE leaderID = 20

That would be number one.....

slick101

Bjom;10922393 wrote:
What are you talking about, please? Where is the second query?
SELECT userID, leaderID FROM myTable WHERE leaderID = 20
That would be number one.....

Maybe you should read what i said instead of being an ass.

I wanted to see if this can be done without doing 2 queries like:

select leader_id from table where user_id = 5

then do antoher query

select user_id from table where leader_id = {result form 1st query}

dagon

leader_id is not the result of that first query as you already know it going in, perhaps if you explained the whole issue you would get appropriate help, there may well be one query that would do what you want, but with so little information no one can help you properly.

slick101

Okay....

I already know the user_id. What I need is to get rows where they are all related to leader_id based off 'user_id'

So i have

5 20
8 20
2 999
94 20

The user that is logged in has the id of 5.
I want to get other users that share the same leader_id

Is there a way to get this information without knowing that leader_id is 20?

instead of doing:
select leader_id from table where user_id = 5
then
select user_id from table where leader_id = $leader_id

-
I already know Select * from table WHERE leader_id = 20

dagon

one way

select user_id from table where leader_id = (select leader_id from table where user_id = 5)

paulnaj

Hmm,

I think you could do it 'old-skool' with an alias. Something like ...

SELECT t2.*
FROM table as t1, table as t2
WHERE t1.leader_id = t2.leader_id
AND t1.user_id = 5

... but Dagon's is a natural solution.

Bjom

Maybe you should read what i said instead of being an ass.

uhuh.

what dagon said... and: straight to the ignore list with you.

Bjom

dagon

you two play nice or the dagon will have to get out the paddle (and nipple clamps)

Bjom

Can I take you up on that? That's the best offer I got in a while 😃