One to One Join

[Lee]

How do I get this to only return one row from the second
table?

Select   a.address_1,  b.address_1
From State_Dup a, State_Class b
where (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]

---