db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John English <john.fore...@gmail.com>
Subject Column is in more than one table?
Date Tue, 28 Sep 2021 11:51:32 GMT
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.

View raw message