I have not come across this syntax before (highlighted in bold):
FROM provider_payments t1
WHERE t1.id = (SELECT MAX(t2.id)FROM provider_payments t2 WHERE t2.account_id = t1.account_id)
Normally after the FROM I would see "tablename1, tablename2" but here I see no comma. I want to learn more about this syntax but because I don't know what it is called, and what it does, I'm having trouble finding more about it on the internet because I don't know what it is called.
The SQL actually does what I want it to do, I just want to learn more about 'what' it's actually doing.