php - How to join 3 sql table -

I have just started learning MySQL, and I have 3 very many tables in the same database, for example: < (Varchar) Table name: T-shirt ID (int, primary key) Name (varchar) Table name: skirts id (int, Name of the primary (name of the primary)

There is an administrative page where I can add a new product, and there is also a select form, so I L am going to the table I could manage.

If you just want to show all the entries in the table, you can do it

  (SELECT * FROM shoes) union (select * FROM tshirt) union (select * FROM skirts);   
 Note: Unions only works on structurally identical tables (i.e. the same number of properties).