troubleshooting Question

What does the following MYSQL syntax do, and mean?

Avatar of James Froggatt
James FroggattFlag for France asked on
SQL
3 Comments2 Solutions5 ViewsLast Modified:
Hi,

I have not come across this syntax before (highlighted in bold):

SELECT t1.*
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.

Thank you
James
SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros