<div>
you can check this article:<br />
<a href="https://www.experts-exchange.com/Database/Miscellaneous/A_3203-DISTINCT-vs-GROUP-BY-and-why-does-it-not-work-for-my-query.html" rel="ugc">https://www.experts-exchange.com/Database/Miscellaneous/A_3203-DISTINCT-vs-GROUP-BY-and-why-does-it-not-work-for-my-query.html</a>
</div>


you can check this article:
https://www.experts-exchange.com/Database/Miscellaneous/A_3203-DISTINCT-vs-GROUP-BY-and-why-does-it-not-work-for-my-query.html [https://www.experts-exchange.com/Database/Miscellaneous/A_3203-DISTINCT-vs-GROUP-BY-and-why-does-it-not-work-for-my-query.html]

<div>
SELECT<br />
&nbsp; &nbsp; p.ProjID, p.ProjName, pc.CommentDate, pc.Comment<br />
FROM Projects p<br />
LEFT OUTER JOIN (<br />
&nbsp; &nbsp; SELECT ProjID, CommentDate, Comment,<br />
&nbsp; &nbsp; &nbsp; &nbsp; ROW_NUMBER() OVER(PARTITION BY ProjID ORDER BY CommentDate DESC) AS row_num<br />
&nbsp; &nbsp; FROM ProjComments<br />
) AS pc ON<br />
&nbsp; &nbsp; pc.row_num = 1 AND<br />
&nbsp; &nbsp; pc.ProjID = p.ProjID<br />
--ORDER BY p.ProjID | ORDER BY p.ProjName
</div>


SELECT
    p.ProjID, p.ProjName, pc.CommentDate, pc.Comment
FROM Projects p
LEFT OUTER JOIN (
    SELECT ProjID, CommentDate, Comment,
        ROW_NUMBER() OVER(PARTITION BY ProjID ORDER BY CommentDate DESC) AS row_num
    FROM ProjComments
) AS pc ON
    pc.row_num = 1 AND
    pc.ProjID = p.ProjID
--ORDER BY p.ProjID | ORDER BY p.ProjName

<div>
<div class="content wysiwyg-content">
I have a sql query question.<br />
I have 2 tables... Projects and ProjComments<br />
<br />
Projects has 2 fields ProjID and ProjName<br />
ProjComments has 4 fields. ProjCommentID, ProjID, CommentDate and Comment<br />
<br />
There can be several comments on one project<br />
<br />
what sql code would I use to select all projects and only the most recent<br />
comment for each project? Some projects won't have any comments.<br />
<br />
so my results would include<br />
ProjID, ProjName, &nbsp;comment Date and Comment.<br />
<br />
thanks!
</div>
</div>


I have a sql query question.
I have 2 tables... Projects and ProjComments

Projects has 2 fields ProjID and ProjName
ProjComments has 4 fields. ProjCommentID, ProjID, CommentDate and Comment

There can be several comments on one project

what sql code would I use to select all projects and only the most recent
comment for each project? Some projects won't have any comments.

so my results would include
ProjID, ProjName,  comment Date and Comment.

thanks!

SQL Select from 2 tables

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.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.