[ad_1]
Yes you can, for this you have to use JOIN and ORDER BY clause.
Ex:
select t1.id, t2.product_id t2.price FROM table1 t1 JOIN table2 t2 ON t1.id = t2.pid ORDER BY t2.price
[ad_2]
solved Sort product data from multiple tables in MySQL
[ad_1]
Yes you can, for this you have to use JOIN and ORDER BY clause.
Ex:
select t1.id, t2.product_id t2.price FROM table1 t1 JOIN table2 t2 ON t1.id = t2.pid ORDER BY t2.price
[ad_2]
solved Sort product data from multiple tables in MySQL