Home -> Usenet -> comp.databases.oracle -> select query - how can i do this

select query - how can i do this

From: <madsere_at_my-deja.com>
Date: 2000/05/06
Message-ID: <8evrm6$9ao$1_at_nnrp1.deja.com>#1/1 






Oh Gurus:



I got a problem with normalizing a database.
A very simple example - assume i have two tables: clients and cities.



clients:


client_id


homezip


workzip



cities:


zip


city



select * from clients:


1,1000,1001


2,2001,2002



select * from cities

1000 city-a
1001 city-b
2001 city-c
2002 city-d





Now, I'd like to make a query that produces a line like



client home work


1 city-a city-b


2 city-c city-d



With just one city it would be easy but with two ...



any suggestions?




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Sat May 06 2000 - 00:00:00 CEST












Original text of this message