Can anyone help me with an SQL statement? I have a database with 2 tables, one for Authors and one for Articles. I came up with the following statement:<BR><BR>SELECT * FROM articles, list WHERE ArticleID = Author ORDER BY ArticleDate DESC<BR><BR>This displays ALL the records. Is it possible to display only the newest 1 article by each author according to ArticleDate? Or must that be filtered out with ASP?