How To Join/combine Two Table When Export Mysql Data To Excel Download?

I Maintain 4 tables. Table 1(table name: products)-> pro_id, pro_model, price Table 2(table name: pro_description)-> id, pro_id, pro_name, pro_desp Table 3(table name: pro_to

Solution 1:

Try a query along these lines:

SELECT
    t1.pro_id,
    t2.pro_name,
    t2.pro_desp,
    t1.price,
    t1.pro_model,
    t4.cat_desp
FROM products t1
INNER JOIN pro_description t2
    ON t1.pro_id = t2.pro_id
INNER JOIN pro_to_category t3
    ON t1.pro_id = t3.pro_id
INNER JOIN category t4
    ON t3.cat_id = t4.cat_id