Multiple results per device

[imaginethat]

Hi all
I am trying to create a report that gives me a few different things, IP, MAC, MachineName, Monitor Serial Number etc.
I have been able to run the existing reports fine, but if I add anything to these reports, or create reports of my own, I get all the data, but there are 10 results for each device.
What am I doing wrong?
Here is an example of a report i have created, and each device gives me 10 results, and the MAC seems to be different on 5 of those results, so a bit odd.
--------------------------------------------------------------------
Select Top 1000000 dbo.tblBIOS.SerialNumber, dbo.tblComputers.Computer
As Hostname, dbo.tblComputers.LastknownIP, dbo.tblNetwork.MACaddress
From dbo.tblComputers Inner Join
dbo.tblBIOS On dbo.tblComputers.Computername = dbo.tblBIOS.Computername
Inner Join
tblSystemEnclosure On dbo.tblComputers.Computername =
tblSystemEnclosure.Computername
Inner Join
tblComputerSystemProduct On dbo.tblComputers.Computername =
tblComputerSystemProduct.Computername
Inner Join
tblNetwork On dbo.tblComputers.Computername = tblNetwork.Computername
---------------------------------------------------------------------

What is the difference between dbo.tblBlablabla.Bla and just tblBlablabla.Bla.
Also I am not sure what the difference is between the "tbl" and the "web40rep" are on the right hand column of the lansweeper config window.
Is the infinite symbol linking the tables important?

Look forward to hearing from you.

cheers

imaginethat

[imaginethat]

Ah ha, thank you very much for the prompt and accurate help.
With the description on the NIC turned on I could see what you mean, there are many virtual NIC devices, so can filter them out.

Thanks again for your help.

cheers

[Hemoco]

I made only a small change to the report

Select Top 1000000 dbo.tblComputers.Computername,
  dbo.tblComputers.ComputerUnique, dbo.tblComputers.Computer As Hostname,
  dbo.tblBIOS.SerialNumber, dbo.tblComputers.LastknownIP,
  tblNetwork.Description, dbo.tblNetwork.MACaddress
From dbo.tblComputers Inner Join
  dbo.tblBIOS On dbo.tblComputers.Computername = dbo.tblBIOS.Computername
  Inner Join
  tblSystemEnclosure On dbo.tblComputers.Computername =
    tblSystemEnclosure.Computername Inner Join
  tblComputerSystemProduct On dbo.tblComputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblNetwork On dbo.tblComputers.Computername = tblNetwork.Computername

I added the description of the network card.
The problem is that each computer can have multiple (virtual) network cards each with their own mac address.

The same applies to tblmonitors, they can have multiple monitors