SELECT equipment.Name AS 'Equipment Name', products.name AS 'Product Name', products.equipmenttype AS 'Type of Equipment',
manufacturers.name AS 'Manufacturer', Equipment.ownerid AS 'Owner ID' FROM Equipment
JOIN products ON equipment.productid = products.productid
JOIN manufacturers ON products.manufacturerid = manufacturers.manufacturerid;