select query - how can i do this

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 CDT