v_station_cruise - View
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

Namev_station_cruise
SQL
SELECT
    DISTINCT gcc.station_name AS sta_sname,
    gcc.cruise_name,
    c.long_name AS cruise_lname
FROM geo_cruisecast gcc,
    collection c
WHERE gcc.cruise_id = c.row_id
        AND gcc.platform_id = 5
        AND gcc.station_id <> 54
ORDER BY gcc.station_name,
    gcc.cruise_name,
    c.long_name