|
From: SourceForge.net <no...@so...> - 2006-02-15 18:19:40
|
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 |