August 10th, 2009, 02:14 PM
Join Date: Aug 2009
Time spent in forums: 51 m 35 sec
Reputation Power: 0
Out of practice - need a hint to correct direction
I have taken a looong break from programming. Other things to to.
Now I have to restart and am stumbling already.
Ive got two tables,
one lists houses and has (amongst others) one field (integer) which holds the key of the city the house is in.
The second table simply lists cities (key; city_name).
Now I need to find the names (or keys) of all cities that have houses.
Would you believe I forgot how to start...
Please someone gimme a push in the right direction... (need sql query statement)
Ah- almost forgot, its Mysql and php we're talking.
Thanks in advance from sunny Tenerife island (Spain)