esi-transform::DATABASE=> select output, o."typeName", input, i."typeName" from product_materials join "invTypes" o on o."typeID"=output join "invTypes" i on i."typeID"=input where output=16671;

 output |     typeName     | input |     typeName
--------+------------------+-------+-------------------
  16671 | Titanium Carbide |  4312 | Oxygen Fuel Block
  16671 | Titanium Carbide | 16654 | Titanium Chromide
  16671 | Titanium Carbide | 16658 | Silicon Diborite

(3 rows)