having trouble using join function in sql : im trying to join two tables using the join function
workbench keeps coming up with error and dont understand why
please help

select city,cityid,countryid
from cities join countries
on cities.CountryID = countries.CountryID;