<div>
&gt;&gt;Hope that is clear enough&lt;&lt;<br />
<br />
sorry to say but doesn't seems much clear to me, can you please provide us with create table script, some data for that table and your desired results?
</div>


>>Hope that is clear enough<<

sorry to say but doesn't seems much clear to me, can you please provide us with create table script, some data for that table and your desired results?

<div>
Thank you! &nbsp; &nbsp; That is exactly what I needed.
</div>


Thank you!     That is exactly what I needed.

<div>
<div class="content wysiwyg-content">
I am having a problem with a query and it is not returning the results I need.<br />
<br />
In the following example (the field 'lev' is NOT providing the matching value for that record (for the 'attempt' that is output)<br />
<br />
Hope that is clear enough<br />

<pre><code id="code-361307">SELECT DISTINCT j.name, max(r.attempt) AS highest, j.active, j.jobID, r.lev
FROM (journals j
LEFT JOIN responses r ON r.jobID=j.jobID)
WHERE j.contactID = 220
GROUP BY r.jobID
</code></pre>
</div>
</div>


I am having a problem with a query and it is not returning the results I need.

In the following example (the field 'lev' is NOT providing the matching value for that record (for the 'attempt' that is output)

Hope that is clear enough

highest attempt in table

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.