Ok thanks, but i cannot get it to work. I have the following:
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblProxy.Computername As Computername1,
tblProxy.Proxyportnumber, tblProxy.Proxyserver, tblProxy.ProxyID
From tblComputers Inner Join
tblProxy On tblComputers.Computername = tblProxy.Computername