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 |