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

Namev_casts_sta_cruise
SQL
SELECT
    gc.coll_id,
    gc.cast_name,
    gc.fixed_date,
    gc.fixed_lon,
    gc.fixed_lat,
    gc.min_z,
    gc.qualifier,
    gc.type_id,
    gc.type_name,
    gc.cruise_name,
    c.long_name AS cruise_lname,
    gc.cruise_id,
    gc.cruise_date,
    gc.station_sname,
    gc.station_name,
    gc.station_id
FROM geo_cast gc,
    collection c
WHERE gc.cruise_id = c.row_id
        AND gc.platform_id = 5
        AND gc.station_id <> 54
ORDER BY gc.cruise_date,
    gc.station_name,
    gc.type_name,
    gc.qualifier,
    gc.fixed_date