SQL Query to retrieve the informations from another table knowing the ids : I have two tables in my db:
Table Flights:
ID
ID_Destination
ID_Source

Table Locations:
ID (that relatesto the id of source and destination)
Name
Country
Etc..

Now I need a query that gives me the information of all flights from a certain source to certain destination. I have tried long in the query editor but inner join does not work here.
What should I use instead?

I would need as a result something like:

1st flight: Naples Italy |London England
2nd flight: Rome Italy | Mailand Italy
etc..
Thanks for help.