mysql - 如何在mysql输出中获得重复的结果？

Question

我对sql有一个简单而愚蠢的疑问。我必须写下如下查询。这里，id不是唯一的。但是当我执行以下查询时，我得到唯一值作为输出。如何获取多个值？

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

Answer 1

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