Maybe I'm missing something but why are you using LEFT JOIN if you want to get read of all records produced by it at the end?
>I have an SQL construct where I have to do a left join and after that I want to get rid of the value that was joined if it's empty
>
>Here's what I did so far
>
>
>select code, nom, nom_anglais, nvl(nombrpoint, 0) as NombrePoint ;
>from produit ;
>left join PointItemGratuit on produit.Code = PointItemGratuit.CodeItem ;
>order by NombrePoint
>
>
>I tried doing the following
>
>
>select code, nom, nom_anglais, nvl(nombrpoint, 0) as NombrePoint ;
>from produit ;
>left join PointItemGratuit on produit.Code = PointItemGratuit.CodeItem ;
>where !empty( NombrePoint) ;
>order by NombrePoint
>
>
>But it returned an empty cursor
>
>How can I get only the non empty (>0) values ?
--sb--