On Tue, 3 Aug 2004 16:15:14 +0100
  "Robertson-Ravo, Neil (RX)"
<[EMAIL PROTECTED]> wrote:
> Use an Inner Join....

I already tried his and it returns more than one.

Select  b.address_1
From State_Dup a inner join State_Class b
on (a.Lname + a.Address_1 + a.City) = (b.Lname +
b.Address_1 + b.City)

Lee Surma
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to