how to create a view in sql with join and sum in phpmyadmin
how to create a view in sql with join and sum in phpmyadmin
0
CREATE VIEW User_Points AS
SELECT u.id, SUM(COALESCE(t.PointsAwarded,0)) AS Points
FROM users
LEFT JOIN tasks t ON u.id=t.EmployeeID
GROUP BY u.id
https://stackoverflow.com/questions/50197110/sum-of-one-column-as-another-column-in-phpmyadmin
Source: Grepper
Twitter 
LinkedIn