2 Replies Latest reply: Mar 22, 2011 3:21 PM by antondsilva RSS

    AQL - Association Not Happening

      Hello,

      I'm trying to load data from 3 tables and this is what is script looks like

      SQL SELECT "IP_ADDRESS"
      FROM SPRTSG4."SPRT_EC_DEVICE";

      SQL SELECT "HARDWARE_GUID"
      FROM SPRTSG4."SPRT_EC_DEVICE";

      SQL SELECT "FIRMWARE_GUID"
      FROM SPRTSG4."SPRT_EC_DEVICE";

      SQL SELECT GUID AS FIRMWARE_GUID
      FROM SPRTSG4."SPRT_EC_FIRMWARE";

      SQLSELECT "FIRMWARE_VERSION"
      FROM SPRTSG4."SPRT_EC_FIRMWARE";

      SQL SELECT GUID AS HARDWARE_GUID
      FROM SPRTSG4."SPRT_EC_HARDWARE";

      SQL SELECT MANUFACTURER
      FROM SPRTSG4."SPRT_EC_HARDWARE";

      However association is not happening despite the fact that I have renamed the columns (HARDWARE_GUID) AND (FIRMWARE_GUID) to be the same as the column names from the SPRT_EC_DEVICE table.

      Any ideas?

      Thanks,

      Anton