 Rank: Administration Groups: Administration, Premium Users
Posts: 10,370
|
try this: Code:Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Computer, Web40OSName.Compimage As icon,
tblComputerSystemProduct.Vendor As Manufacturer, tblComputerSystemProduct.Name
As Model, Web40OSName.OSname, Web40OSName.SP, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
tblComputers.LastknownIP, tblOperatingsystem.InstallDate
From tblComputers Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername
Order By tblComputers.Computer
|
