>Update:
>I had to fiddle somewhat, but I could imagine this would be working:
>
>WITH ranked_status AS (
> SELECT Orders.Id, Orders.KdNr, Orders.Status, ROW_NUMBER() OVER (PARTITION BY KdNr ORDER BY id DESC) AS row_number
> FROM Orders AS m
>)
>SELECT Auftrag.KdNr, Min_Id.Id, Max_Status.Status
>FROM Auftrag
>JOIN (SELECT MIN(Id) AS Id, KdNr FROM Orders GROUP BY KdNr) Min_Id ON Min_Id.KdNr = Auftrag.KdNr
>JOIN (SELECT Status, KdNr FROM ranked_status WHERE row_number = 1) Max_Status ON Max_Status.KdNr = Auftrag.KdNr
Thanks