--- Steve SAUTETNER <steve@sautetner.com> wrote:
> SELECT * FROM famille WHERE famille_code NOT IN
> (SELECT DISTINCT famille_mere_famille_code FROM famille);"
try
select * from famille f1 where not exists
(select 1 from famille f2 where f1.famille_code = f2.famille_mere_famille_code);
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com