MySQL

[dR.LoL]

Joa, ech ben de bescht ;-))
Hans voll powned!

SELECT tblPackage.Id AS PackageId, tblPackage.isBase, tblPackage.Name, tblPackage.Version, tblPackage.Path, tblPackage.Filename, tblTesting.Fk_PackageId, tblTesting.Fk_StatusId, tblTesting.AssignedDate, tblStatus.Specification
FROM SIS.tblTesting
INNER JOIN (SIS.tblPackage, SIS.tblStatus)
ON (tblPackage.Id = tblTesting.Fk_PackageId AND tblStatus.Id = tblTesting.Fk_StatusId)
WHERE tblPackage.Id IN
  (SELECT tblTesting.Fk_PackageId FROM SIS.tblTesting ORDER BY tblTesting.AssignedDate DESC)
GROUP BY tblTesting.Fk_PackageId
ORDER BY tblPackage.Name ASC, tblPackage.isBase DESC, tblPackage.Version ASC