Sammy,

Thanks for the reply.  Yes, I've done that, and although it only returns one 
of each CODE, it doesn't return any EQUIV, which is what I need.  Any 
pointers??

Sean


----Original Message Follows----
From: "Sammy Msafiri" <sammy@s...>
Reply-To: "sql language" <sql_language@p...>
To: "sql language" <sql_language@p...>
Subject: [sql_language] Re: SQL DISTINCT
Date: Tue, 2 Jan 2001 14:18:05 +0300

Hi There
               HAPPY NEW YEAR
               Have you tried distinct row on CODE only.  Tried that and see
what happens

Sammy


---
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com