[Solved] joining two related tables in mysql


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

solved joining two related tables in mysql