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.

I have been bumping my head off this for hours any help is appreciated.

First Image is RegisteredUsers Table and Second is StripeImport