phantom phantom - 1 year ago 70
MySQL Question

using innerJoins mysql

I have a table database called jobs with 2 tables. One is vacancies and the other is location. It looks something like this



I want to get the location number from the vacancies table and then use this to choose the id from the locations table. For example, if the location was 5 in the
table I would want to use this number, put it as the id in the
table and get the corresponding country.

See my current attempt below.

SELECT * FROM careers.vacancies
INNER JOIN careers

My sql leaves a bit to be desired so please forgive me if my query is way off.

Answer Source
SELECT, FROM vacancies
INNER JOIN locations ON =;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download