Since you gave no real details of your table structure, I'll conjecture.
Assume city table and advert table is defined as:
CREATE TABLE city (
city_id int not null, auto_increment,
city_name varchar(50) default ""
)
CREATE TABLE adverts (
ad_id int not null auto_increment,
ad_text varchar(200) d
Hi Balazs,
> The situation: I have 2 tables in an adverising site. In one table, i have
> the cities used by advertisers, and in the other there are the ads.This ad
> table has a field which refers to the id of the city in that table.
>
> The problem: what mysql method should i use if i want to