Avatar of Bruce Gust
Bruce Gust
Flag for United States of America

asked on 

What would the alternative be to this subquery?

I have this as a subquery in my SELECT:

 LEFT JOIN requirements r ON t.ID = (SELECT r.INTID_ FROM requirements r WHERE r.INTID_=t.ID ORDER BY r.ID DESC LIMIT 1)

One of my team members suggested that I use a different approach by using "MAX."

You have a one to many relationship and the, "r.INTID_" that I want to connect with is the most recent row, hence my sorting by ID.

How would I incorporate the MAX() function in this scenario so I'm accomplishing the same thing, but in a way that is, perhaps, a little more efficient?

MySQL Server

Avatar of undefined
Last Comment
Bruce Gust

8/22/2022 - Mon