0 Replies Latest reply on Dec 6, 2010 2:48 PM by hossein1982

    Select Query, Fields name repeated!!


      I join two query and execute the sql query without any problem, but the fields name that I SELECT repeated and doesnt show the correct fileds name, this is my query

      SELECT vendor, Caption, IP_address, q1.OutrageTime as down, q2.Uptime as uptime

      FROM (....) q1

      INNER JOIN (....) q2

      ON (....)

      the query executed but the Fields name  of " q1.OutrageTime as down, q2.Uptime as uptime" shows as IP_address only.

      that two fields are generated in q1 and q2 queries.

      what should I do to solve this problem? This is very important, because I should print that report to my manager.