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
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