SELECT * FROM
(
SELECT distinct tblComputers.Computername, tblComputers.Username
FROM tblComputers, tblADComputers, tblSoftware
WHERE tblADComputers.Computername = tblComputers.Computername
AND tblSoftware.ComputerName = tblADComputers.Computername
AND tblADComputers.OU LIKE '%OU=XXXX,DC=XXXX,dc=XXXX'
AND softwareName LIKE '%Microsoft Office Enterprise 2007%'
) A
,
(
SELECT distinct tblComputers.Computername, tblComputers.Username
FROM tblComputers, tblADComputers, tblSoftware
WHERE tblADComputers.Computername = tblComputers.Computername
AND tblSoftware.ComputerName = tblADComputers.Computername
AND tblADComputers.OU LIKE '%OU=XXXX,DC=XXXX,dc=XXXX'
AND softwareName LIKE '%Microsoft Office Professional Edition 2003%'
) B
WHERE A.Computername = B.Computername
If anyone is interested in using this.
