SqLite - Query with two tables

I have two tables. The first table is photos and it has the fields:

id, stationId, walkId, imageName

The second table is stations and its fields:

stationId, name, walkId, description, turn

I want to get the field imageName from table photos and I want these records to be ordered by field turn from table stations.