[Firebird-devel] [ firebird-Field-test-1432354 ] Error in SQL query

[SourceForge.net <no...@so...>]

Field-test item #1432354, was opened at 2006-02-15 15:19
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=593943&aid=1432354&group_id=9028

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Alejandro (casagrandeale)
Assigned to: Nobody/Anonymous (nobody)
Summary: Error in SQL query

Initial Comment:
Hi, i am using firebird 1.5.2 in production, and now i 
downloaded firebird 2.0 beta 2 just for testing and i 
have an error with this query 

select PI.*,
       programas.clave as clave
from perfiles_items pi
join programas p on pi.id_programa = p.id_programa
where pi.id_perfil = :ID_PERFIL

in firebird 1.5.2 it is working fine but in firebird 
2.0 give me the error that the programas.clave column 
is unknown.

But if i change the query in this way, it works fine. 
I know that the query problably was bad written in the 
first time

select PI.*,
       p.clave as clave
from perfiles_items pi
join programas p on pi.id_programa = p.id_programa
where pi.id_perfil = :ID_PERFIL

Regards!

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=593943&aid=1432354&group_id=9028