SELECT computers.employee, printers_scanners.brandname, IpAddress.ipaddress
FROM (computers INNER JOIN IpAddress ON computers.[IP Address] = IpAddress.ipaddress) INNER JOIN printers_scanners ON IpAddress.ipaddress = printers_scanners.ip_address;
I have one table with every possible ip address that is allowed in my system
one table with all pc's
one table with all printers
one table with all rack mounted equipment.
the common field is the ip address
I need a list of every piece of equipment in my system.
The query above was an experiment to try to bring out all ip in the computer table and all ip in the printer table; but it come up blank.