and its LIMIT 1...not sure for access or Oracle.
On Tue, 03 Aug 2004 10:30:34 -0500, Lee <[EMAIL PROTECTED]> wrote:
> 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]
