_____
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 03 August 2004 16:15
To: CF-Talk
Subject: One to One Join
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]
