MySQL

[dR.LoL]

Erweiterung:
Dieses Statement sieht aus als würde es funktionieren (Nach meinem Hirn) doch leider, kann man kein LIMIT im IN brauchen :((

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 LIMIT 1)
ORDER BY tblPackage.Name ASC, tblPackage.isBase DESC, tblPackage.Version ASC