Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL- question

SQL- question

From: Ulf Grindstad <griulf_at_online.no>
Date: Wed, 7 Jul 1999 15:25:48 +0200
Message-ID: <RBIg3.168$hg4.1472@news1.online.no>


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 Received on Wed Jul 07 1999 - 08:25:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US