| 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
|