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
(2.1) By Harald Hanche-Olsen (hanche) on 2021-07-26 20:41:14 edited from 2.0 in reply to 1 [source]
AND WHERE is a syntax error. Replace by
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);