db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: Column is in more than one table?
Date Tue, 28 Sep 2021 14:58:38 GMT
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;


Mime
View raw message