On 9/28/21 4:51 AM, John English wrote:
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?
This looks like a bug to me, but one with an easy workaround:
SELECT s.time,s.facility FROM system_log s,(SELECT time FROM system_log ORDER
BY facility) AS x WHERE s.time=x.time;