In article <40928C26.1000309@...>, Rpoulin wrote:

> select d1.PRIX_MARGE_DETAIL - d2.PRIX_MARGE_DETAIL
> from DETAIL_KIT d1
> left join DETAIL_KIT d2 on d1.no_ordre = d2.no_ordre
> where d2.PRINCIPAL ='N'
> and d1.PRINCIPAL ='O'
> order by d1.NO_ORDRE;

you need an INTO clause

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly