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