PHP Developer

Bruce Gust

<div>
Hey, ste5an!<br><br>The problem is that the query throws an error because there's more than one "match" in the requirements table.<br><br>This got the job done...<br><br>LEFT JOIN requirements r on t.ID = r.INTID_ and r.ID = (select MAX(ID) from requirements where INTID_ = t.ID)<br><br>Thanks for your feedback!
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have this as a subquery in my SELECT:<br><br>&nbsp;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) <br><br>One of my team members suggested that I use a different approach by using "MAX."<br><br>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.<br><br>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?<br><br><br>
</div>
</div>



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?

What would the alternative be to this subquery?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.