SQLite Forum

How do I do a one - many join?
Login
`AND WHERE` is a syntax error. Replace by `AND`.

Anyhow, I think your query is better written as a join:

```
SELECT s.station_name, s.start_lat, s.start_lng, started_at, ended_at, duration
FROM stations AS s
JOIN detail AS d
ON (s.start_lat = d.start_lat AND s.end_lat = d.ended_at);
```