What type of MYSQL JOIN do I need

[eMonk]

My old query was:

$query = "SELECT city_name FROM city WHERE province_id = 9";

Now I'm using:

$city = $_GET['city'];

and just have the city name now but need to fetch all the cities in the province that $city is in.

Here are my tables:

Table: city
column: city_name = Vancouver, Victoria, Edmonton
column: province_id = 9, 9, 8

Table: province
column: id = 8, 9
column: name = Calgary, British Columbia

So if $city is in province British Columbia, what type of join to I need to fetch all cities listed in British Columbia?

[nm_]

SELECT city_name FROM city WHERE province_id IN (SELECT province_id FROM city WHERE city_name = $city) ???

[eMonk]

That worked thanks!

[Adult Insider Dave]

If you ever need major coding help contact me anytime!