If I issue the following query:SELECT t_time,facility FROM system_log,(SELECT time FROM system_log ORDER BY facility) AS x WHERE system_log.time=x.time
I get an error: "Column name 'FACILITY' is in more than one table in the FROM list."
Why does it consider Facility to be a column in table X? Is this correct behaviour, or is it a Derby bug?
-- John English -- This email has been checked for viruses by AVG. https://www.avg.com