So I have two tables RegisteredUsers and Soldtickets (this is an import) I want to import a sum of all the sold tickets by PlayerID from Soldtickets on a select query from RegisteredUsers with all the data (Select *) the PlayerID and Identifier from Registered Users should be the same and if there is no sum I would like to return a 0.