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.