How do I do a one - many join?
(1) By David Jackson (davidjackson) on 2021-07-26 20:25:29 [link] [source]
How am trying to combine tables stations and detail. I want to use the longitude and latitude files for the join. I want all the records from stations and all the matching records from detail. Here is the SQL I am trying to run:
SELECT s.station_name,s.start_lat,s.start_lng,started_at,ended_at,duration FROM stations AS s,detail AS d WHERE s.start_lat = d.start_lat AND WHERE s.end_lat = d.ended_at
TX, David
(2) By Harald Hanche-Olsen (hanche) on 2021-07-26 20:40:40 in reply to 1 updated by 2.1 [source]
`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); ```
(2.1) By Harald Hanche-Olsen (hanche) on 2021-07-26 20:41:14 edited from 2.0 in reply to 1 [link] [source]
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);