‎04-02-2009 03:26 AM
‎04-02-2009 10:41 PM
‎04-02-2009 12:41 PM
SELECT TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblSerialnumber.Product, dbo.tblSerialnumber.ProductID, dbo.tblSerialnumber.ProductKey,
dbo.tblSerialnumber.Lastchanged
FROM dbo.tblComputers INNER JOIN
dbo.tblSerialnumber ON dbo.tblComputers.Computername = dbo.tblSerialnumber.Computername
GROUP BY dbo.tblComputers.Computername, dbo.tblSerialnumber.Product, dbo.tblSerialnumber.ProductID, dbo.tblSerialnumber.ProductKey,
dbo.tblSerialnumber.Lastchanged
HAVING (dbo.tblSerialnumber.Product = 'Microsoft Office Professional Edition 2003')
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now