Problem bei MySQL Query

[dR.LoL=>Erledigt]

Hallo, habs endlich hingekriegt, hab von 'Union' grad eben das erste mal was gehört ;-))

cYa

PS:
(SELECT tblPackage.Id AS PackageId, tblPackage.Name AS PackageName, tblPackage.Version AS PackageVersion, tblServer.Id AS ServerId, tblServer.Fk_CustomerId, tblServer.Name AS ServerName, tblServer.Location FROM SIS.tblInstallation INNER JOIN (SIS.tblServer, SIS.tblPackage) ON (tblServer.Id = tblInstallation.Fk_ServerId AND tblPackage.Id = tblInstallation.Fk_BasePackageId) WHERE tblInstallation.isLatest = '1') UNION (SELECT 0, 0, 0, tblServer.Id AS ServerId, tblServer.Fk_CustomerId, tblServer.Name AS ServerName, tblServer.Location FROM SIS.tblServer WHERE tblServer.Id NOT IN (SELECT tblInstallation.Fk_ServerId FROM SIS.tblInstallation))