At 09:19 AM 4/23/2001 +0200, Fabrice Vendé - INFOCOB wrote:

>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
>
>results :
>
>2ES | 016 016 155| 139 | 544,25 ..
>
>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
>
>results :
>
><Null> | <Null> | 139 | 544,25 ..
>
>Why C_name and c_phone are egual to <null> with the desc clause ?

Probably because you've violated one of the Commandments of the
SQLeena - don't mix SQL-89 & SQL-92 join syntaxes. You are right,
of course, that changing the ORDER BY from asc to desc shouldn't
affect the results since the order is applied after the joins (in
theory).



Regards,

Ann
www.ibphoenix.com
We have answers.