---

Kan

SELECT DISTINCT dbo.Category.CategoryName,
(SELECT TOP (1) NewsHeader
FROM dbo.News AS News_1
WHERE (CategoryID =
dbo.Category.CategoryID)
ORDER BY NewsID DESC) AS NewsHeader
FROM dbo.Category INNER JOIN
dbo.News AS News ON dbo.Category.CategoryID =
News.CategoryID


laves uden sub-select..bare med joins?

For hver kategori skal listes senest tilføjede nyhed.


mvh
--
Database- & webudvikling
www.dbconsult.dk

---

Morten Snedker skrev:

> SELECT DISTINCT dbo.Category.CategoryName,
> (SELECT TOP (1) NewsHeader
> FROM dbo.News AS News_1
> WHERE (CategoryID =
> dbo.Category.CategoryID)
> ORDER BY NewsID DESC) AS
> NewsHeader
> FROM dbo.Category INNER JOIN
> dbo.News AS News ON
> dbo.Category.CategoryID =
> News.CategoryID


SELECT CategoryName, NewsHeader
FROM dbo.Category c
INNER JOIN (
   SELECT CategoryID, max(NewsID) as newsID
   FROM dbo.News
   GROUP BY CategoryID
   ) x
ON c.categoryID = x.categoryID
INNER JOIN News n
ON x.newsID = n.newsID


--
Jens Gyldenkærne Clausen
»Diplomatiet består netop i, at de gamle kommatister kan få lov til
at tro, at de har vundet. Men i virkeligheden har de tabt.«
Ole Togeby i Information

---

Mange tak for det!

mvh