Curious problem with interbase 6.0 :

With IBConsole, this query :
select Q3.c_name,Q3.c_phone,Q1.*
from PRODUITFICHE Q1 ,PRODUITDESIREFICHE Q5
left join CONTACTFICHE Q3 on Q1.p_codecontact=Q3.c_code
where Q1.p_codemodele=Q5.pd_nomproduit
and Q5.pd_codecontact="OUEST1354COB"
order by Q1.P_NAME

Return me :
C_Name | C_PHONE | P_CODE | P_COST ..
2ES | 016 016 155| 139 | 544,25 ..


But :
select Q3.c_name,Q3.c_phone,Q1.*
from PRODUITFICHE Q1 ,Produitdesirefiche Q5
left join CONTACTFICHE Q3 on Q1.p_codecontact=Q3.c_code
where Q1.p_codemodele=Q5.pd_nomproduit
and Q5.pd_codecontact="OUEST1354COB"
order by Q1.P_NAME desc
(Only order clause change)


Returne me :
C_Name | C_PHONE | P_CODE | P_COST ..
<Null> | <Null> | 139 | 544,25 ..

Why C_name and c_phone are egual to <null> with the desc clause ?



Fabrice Vendé
-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
http://www.infocob.com



[Non-text portions of this message have been removed]