TRAINGEEK.CA

SIGHTINGS

CLASS 1

SHORTLINES

MUSEUMS

DOCS

Start Date/time
End Date/time
Reporting Mark
Unit Number

SELECT U.roadmark, U.number, U.sightingID FROM units U WHERE (U.roadmark = 'CCGX') AND (U.number = 5311)
SELECT S.dt, S.trainnum, S.comments, L.name, L.provstate, S.locationID FROM sightings S, locations L WHERE (S.ID = 3033) 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 = 3052) 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 = 3085) 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 = 3092) 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 = 3177) 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 = 3232) 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 = 3243) 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 = 3247) AND (S.locationID = L.ID)

Date/Time

Location

Prov

Train #

Comments

---

Add a sighting