Xref: alice comp.databases.oracle.misc:35522
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed1.online.no!newsfeed.online.no!news1.online.no!not-for-mail
From: "Ulf Grindstad" <griulf@online.no>
Newsgroups: comp.databases.oracle.misc
Subject: SQL- question
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Message-ID: <RBIg3.168$hg4.1472@news1.online.no>
Date: Wed, 7 Jul 1999 15:25:48 +0200
X-Complaints-To: news-abuse@online.no
X-Trace: news1.online.no 931354097 62.92.53.118 (Wed, 07 Jul 1999 15:28:17 MET DST)
NNTP-Posting-Date: Wed, 07 Jul 1999 15:28:17 MET DST
Organization: Telenor Online Public Access

I have to tables who is connected like this:

Table A(parent)
 parent_number

Table B(child)

child_number
child_zipcode
---
The two tables are connected with parent_number = child_number

I want to find every parent that have two or more childs with the same
zip_code.
How do I do that?

Ulf