When I send a product, the category is shown and the type of the product is not. Please tell me how to combine 2 tables (table_products and category) 2 columns of the table type_tovara and type so that they correspond to brand and category. It seems to write clearly)

enter image description here

  • Through union select category, type_tovara from table_products union select brand, type from category - nick_n_a
  • @nick_n_a And it seemed to me that join. although of course it is not clearly written. Here I sit looking for the most appropriate answer with joins that would close on the double. every day they ask, but dial in the search here "[mysql] two tables" and it's hard to see examples just ... - Mike
  • 2
    join joins table columns, usually in a key field. And union joins / merges two tables. Therefore, depending on what you call "integrate" - nick_n_a

0