Re: SQL Newbie ?

[Dave Shaw <daveshaw@xxxxxxxxxxxxx>]

Instead of specifying not equal, specify greater than or less than.  That 
should give you something like this:

ABCD                EFGH
ABCD                QRST
EFGH                QRST

> 
> From: Mark Allen <mallen@xxxxxxxx>
> Date: 2003/09/12 Fri AM 10:01:48 EDT
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL Newbie ?
> 
> Is there a way to do this in SQL?
>  
> File as such
>  
> Sub Acct        Account        Address
> ABCD                ABCD        XYZ
> EFGH                EFGH        XYZ
> IJKL                    IJKL          ABC
> MNOP                IJKL           ABC
> QRST                QRST        XYZ
>    
> I want to list those who have matching addresses but the account is not
> the same
>  
> So from above I want to see:
>  
> First                    Possible Match
> ABCD                   EFGH
> ABCD                    QRST
> I've kinda got it working in query but it gives me
>  
> ABCD                EFGH
> ABCD                QRST
> EFGH                ABCD
> EFGH                QRST
> QRST                ABCD
> QRST                EFGH
>  
> which makes the list huge
>  
> I know I can do it in RPG but looking for a SQL solution if possible
>  
>  
> Mark Allen
> IS Manager
> Wilkes Telephone & Electric
> 11 W. Court Street
> Washington, GA 30673
> Phone: (706) 678-9565
> Fax: (706) 678-1000
>  
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>