| xan [xan_PRISM_DW.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| nvs.v_casts_sta_cruise | (View) |
| Name | v_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
|