SQL Query Issues

[daytime10]

I am running the following query on 4.2.0.5

Database schema: 14
Website version: 4022

SELECT DISTINCT tblComputers.Computer, tblComputers.Username, tblComputersystem.Model, tblPROCESSOR.Name, tblComputersystem.TotalPhysicalMemory, tblComputerSystemProduct.IdentifyingNumber, tblADusers.Department, tblCompCustom.Warrantydate FROM tblComputers INNER JOIN tblADusers ON tblComputers.Username = tblADusers.Username INNER JOIN tblComputersystem ON tblComputers.Computername = tblComputersystem.Computername INNER JOIN tblPROCESSOR ON tblComputers.Computername = tblPROCESSOR.Computername INNER JOIN tblComputerSystemProduct ON tblComputers.Computername = tblComputerSystemProduct.Computername INNER JOIN tblCompCustom ON tblComputers.Computername = tblCompCustom.Computername ORDER BY tblComputers.Username

For some reason the query is only pulling non active machines... on our older version 4.1.0.16, this query worked fine....

Database schema: 12
Website version: 4019

Any thoughts or help would be greatly appreciated 🙂

[daytime10]

That worked!

Thanks so much appreciate it!

[Hemoco]

try this

Select Distinct tblComputers.Computer, tblComputers.Username,
tblComputersystem.Model, tblPROCESSOR.Name,
tblComputersystem.TotalPhysicalMemory,
tblComputerSystemProduct.IdentifyingNumber, tblADusers.Department,
tblCompCustom.Warrantydate
From tblComputers Left Join
tblADusers On tblComputers.Username = tblADusers.Username And
tblComputers.Userdomain = tblADusers.Userdomain Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblPROCESSOR On tblComputers.Computername = tblPROCESSOR.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Order By tblComputers.Username