[Solved] joining two related tables in mysql

[ad_1]

This Following Query Worked For Me :

SELECT *, orders.id AS id, orders.name AS name FROM orders 
LEFT JOIN cart ON orders.authID = cart.authID
WHERE orders.id != '0'
GROUP BY orders.authID

[ad_2]

solved joining two related tables in mysql