Complete the following problem using basic SQL commands.  Basic SQL
means not specifically tied to TSQL, SQL PL or DB 2 Versions.
if I am given a table with the addresses of consumers to whom we wish
to send junk mail.  The table has a fam(family) column that links
Consumers with the same street address.  We need this because our
rules are that we mail only one offer to a household.  The field
contains the PK value of the Consumers record of the first person who
had this address, thus:
Consumers
Name		address			id		fam
 Bob		A			1		Null
 Joe		B			3		Null
 Mark		C			5		Null
Mary		A			2		1
Vickie		B			4		3
Wayne		D			6		null

We need to delete those rows where fam is null but there are other
family members on the mailing list.  How would you do it in SQL?

---

Clarification of Question by fahd-ga on 26 Sep 2002 20:31 PDT

please remove this question 
this question is a repeat of the same posted question.
Thank you for understanding.