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 = 'CN') AND (U.number = 2275)
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 1570) AND (S.locationID = L.ID)
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 1923) AND (S.locationID = L.ID)
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 1980) AND (S.locationID = L.ID)
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 2114) AND (S.locationID = L.ID)
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 2242) AND (S.locationID = L.ID)
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 2721) AND (S.locationID = L.ID)
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 3469) AND (S.locationID = L.ID)
Date/TimeLocationProvTrain #Comments


Add a sighting