Generate a list of printer with IP address

Generate a list of printer with IP address

Hello, Grateful if you could advise what is the mistake in it. All are generated from SDP in this custom query except the [ MAX("networkinfo"."IPADDRESS") AS "IP Address" ] part.

SELECT MAX("productType"."COMPONENTTYPENAME") AS "Product Type", MAX("resource"."RESOURCENAME") AS "Asset Name", MAX("product"."COMPONENTNAME") AS "Product", MAX("state"."DISPLAYSTATE") AS "Asset State", MAX("networkinfo"."IPADDRESS") AS "IP Address", MAX("resource"."ASSETTAG") AS "AMR No", MAX("deptDef"."DEPTNAME") AS "Department", MAX("aaaUser"."FIRST_NAME") AS "User", MAX("rToAssetResource"."RESOURCENAME") AS "Associated To", MAX("resFields"."UDF_CHAR1") AS "Asset associated to Section"  FROM "Resources" "resource" LEFT JOIN "ComponentDefinition" "product" ON "resource"."COMPONENTID"="product"."COMPONENTID" LEFT JOIN "ComponentType" "productType" ON "product"."COMPONENTTYPEID"="productType"."COMPONENTTYPEID" LEFT JOIN "ResourceState" "state" ON "resource"."RESOURCESTATEID"="state"."RESOURCESTATEID" LEFT JOIN "ResourceOwner" "rOwner" ON "resource"."RESOURCEID"="rOwner"."RESOURCEID" LEFT JOIN "ResourceAssociation" "rToAsset" ON "rOwner"."RESOURCEOWNERID"="rToAsset"."RESOURCEOWNERID" LEFT JOIN "Resources" "rToAssetResource" ON "rToAsset"."ASSTTORESOURCEID"="rToAssetResource"."RESOURCEID" LEFT JOIN "SDUser" "sdUser" ON "rOwner"."USERID"="sdUser"."USERID" LEFT JOIN "AaaUser" "aaaUser" ON "sdUser"."USERID"="aaaUser"."USER_ID" LEFT JOIN "DepartmentDefinition" "deptDef" ON "rOwner"."DEPTID"="deptDef"."DEPTID" LEFT JOIN "Resource_Fields" "resFields" ON "resource"."RESOURCEID"="resFields"."RESOURCEID" WHERE  ( "productType"."COMPONENTTYPENAME" = N'Printer' )   GROUP BY "resource"."RESOURCEID"