I am trying to retrieve all records that contain NULL in a paticular field
and from those, only a single occurance of a SSN. Somewhat like:
Select * from Table where addresss = NULL
and ( select * from that resultset where their SSN is not repeated)
So out of the ones that have nothing in a feild, I only want a single
occurance of the record based on their SSN. (i.e Two records for customer
123-45-6789 only show up once) Thanks for your help
Bob
rmaggio_at_courts.state.ny.us
or
zekmoe_at_aol.com
Received on Fri Mar 05 1999 - 15:43:56 CST
