___ Sat Feb 28 16:30:02 1998 ___________________________________________________
1> select st.station_id, station_name, sensor_num, dur_code
2> from station st, sensor sr
3> where st.station_id = sr.station_id and county_num = 56
4> and sensor_num in (2,16,45)
5> order by station_name, dur_code, sensor_num
+------+----------------------------------------+-------------+------+
|STATIO|STATION_NAME |SENSOR_NUM |DUR_CO|
+------+----------------------------------------+-------------+------+
|ALO |ALISO CANYON | 16|E |
|CHE |CHESEBRO | 2|H |
|CXR |CIRCLE X RANCH | 16|E |
|NRD |NORDHOFF RIDGE | 16|E |
|OXN |OXNARD | 2|M |
|ROV |ROSE VALLEY | 2|H |
|SFD |SANTA FELICIA DAM | 16|E |
|PAL |SANTA PAULA | 2|M |
|SME |SOUTH MOUNTAIN EAST | 16|E |
|SYC |SYCAMORE CANYON | 16|E |
|VTU |VENTURA COUNTY GOVERNMENT CENTER | 16|E |
+------+----------------------------------------+-------------+------+
(11 rows)
2> commit
End of Request
________________________________________________________________________________
