how to get duplicate results in mysql output?

Question

I have a simple and silly doubt in sql. I have to write down a query like the one below. Here, id is not unique. But when i do the following query i get unique values as output. How do i get multiple values?

select name from students_table where id in (select id from students_id);

Ex : Lets say students_table has name   id
                                 -----  ---
                                 john    1
                                 jack    2

     And students_id table has   id    
                                 ---
                                  1
                                  1
                                  1
                                  2
                                  ...

If i write the query in the above way i get name
                                            ----
                                            john
                                            jack

Instead i want my output as name
                            ----
                            john
                            john
                            john
                            jack

check my answer below. i'm pretty sure it worked! :D

John Woo
– John Woo

2012-09-06 22:42:55 +00:00
Commented Sep 6, 2012 at 22:42 — John Woo
– John Woo, Commented Sep 6, 2012 at 22:42

desimusxvii · Accepted Answer · 2012-09-06 22:34:37Z

2

select st.name from students_id si
join students_table st on st.id = si.id;

answered Sep 6, 2012 at 22:34

desimusxvii

1,0941 gold badge8 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Woo · Accepted Answer · 2012-09-06 22:33:07Z

1

You need to JOIN both tables. Try this,

SELECT  a.Name
FROM    student_table a
        INNER JOIN student_ID b
             on a.ID = b.ID

This is what you are looking for.

answered Sep 6, 2012 at 22:33

John Woo

265k70 gold badges509 silver badges500 bronze badges

Comments

m4573r · Accepted Answer · 2012-09-06 22:34:54Z

0

You want to do a join:

select t1.name from students_table t1 inner join students_id t2 on t1.id = t2.id

answered Sep 6, 2012 at 22:34

m4573r

9907 silver badges17 bronze badges

Collectives™ on Stack Overflow

how to get duplicate results in mysql output?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related