Comparing two tables for difference
<p>I want to compare 2 different tables. Both tables include departure and arrival time with datatype Time like 08:30:00. I want to compare the tables for delays in departure time and arrival time. I was playing around with Except in LINQ but nothing seems to work. I am using asp.net mvc 3.</p>

<p>Let me be more specific. There are 4 tables in total, Train with TrainID, Station with StationID and StationName, Schedule with ScheduleID, TrainID, StationID, ArrivalTime and DepartureTime, and Registration with RegistrationID, TrainID, StationID, ArrivalTime and DepartureTime. TrainID and StationID are foreign keys in Schedule and Registration tables, but theres no relashionship between tables Schedule and Registration.</p>

<p>Schedule table is read-only.</p>

<p>So all i want is to know everytime there is a delay in the Registration table compared with the Schedule table so i can do some statistics on the delays.</p>
