My question is related to SQL. I need to pull values from two different tables. I am not successful in doing that. I am able to join the two tables with only a single condition but not many values which using
IN. Here's my current code:
select CP.ID "Control Point ID" , CP.Station "Station" , CP.Station_Series "Station_Series" , SS.Beg_station "Begin Station" , SS.End_Station "End Station" , CP.Status "Status" from Control_Point CP, Station_Series SS where CP.Station_series = SS.ID;
This gives me all the values based on a
JOIN but I need only those records which have a value in
CP.ID. Something like
where CP.ID in (1, 2, 3).