How to implement join of two tables without duplicate id columns?

Question

MySQL

Query: SELECT * FROM reg_admin JOIN more_people_info ON reg_admin.user_id = more_people_info.user_id Result
:

That is, you need to display user_id only at the beginning, and remove the one in the middle

Answer 1

Well, list all the required columns, instead of *

Answer 2

SELECT reg_admin.*, more_people_info.{список полей, которые нужны из этой таблицы}