SQL Widget - Query all the sensors with their associated devices

SELECT "dcSensorPorts"."SensorPortID","dcSensorPorts"."ItemID","dcSensorPorts"."PortName", "dcSensorPorts"."Subclass","dcSensorPorts"."ValueActual", "dcAllItems"."ItemName", "dcAllItems"."Class",

"dcCabinetRUs"."ItemName", "dcCabinetRUs"."ItemType", "dcCabinetRUs"."Make", "dcCabinetRUs"."Model"

FROM odbc."dcSensorPorts" inner join odbc."dcAllItems" ON "dcSensorPorts"."ItemID"="dcAllItems"."ItemID"

inner join odbc."dcCabinetRUs" ON "dcSensorPorts"."CabinetID"="dcCabinetRUs"."ItemID" order by "dcSensorPorts"."SensorPortID"

  • Created by: Gary Elango
  • Date Created: Tuesday, 01 August 2017
SQL
Read 199 times

Related items