TRAINGEEK.CASIGHTINGSCLASS 1SHORTLINESMUSEUMSDOCS

Start Date/time
End Date/time
Reporting Mark
Unit Number
 
SELECT U.roadmark, U.number, U.sightingID FROM units U WHERE (U.roadmark = 'nbec') AND (U.number = 1834)
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 190) AND (S.locationID = L.ID) AND (S.dt >= '1990/1/1') AND (S.dt <= '2009/11/28')
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 304) AND (S.locationID = L.ID) AND (S.dt >= '1990/1/1') AND (S.dt <= '2009/11/28')
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 330) AND (S.locationID = L.ID) AND (S.dt >= '1990/1/1') AND (S.dt <= '2009/11/28')
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 333) AND (S.locationID = L.ID) AND (S.dt >= '1990/1/1') AND (S.dt <= '2009/11/28')
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 349) AND (S.locationID = L.ID) AND (S.dt >= '1990/1/1') AND (S.dt <= '2009/11/28')
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 386) AND (S.locationID = L.ID) AND (S.dt >= '1990/1/1') AND (S.dt <= '2009/11/28')
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 458) AND (S.locationID = L.ID) AND (S.dt >= '1990/1/1') AND (S.dt <= '2009/11/28')
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 463) AND (S.locationID = L.ID) AND (S.dt >= '1990/1/1') AND (S.dt <= '2009/11/28')
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 493) AND (S.locationID = L.ID) AND (S.dt >= '1990/1/1') AND (S.dt <= '2009/11/28')
Date/TimeLocationProvTrain #Comments


Add a sighting