I am a little unsure what you mean by “column that links the two”
Basically I need to subtract the first query’s "originalAlarmT ime" from the second query’s "originalAlarmT ime".

Sorry for my ignorance, I am very new to this as I am an electrician working with building management systems.

I need to subtract 2 datetime values.

The values are from the same view table but 2 different rows.

The points in the table are Alarm points which are generated via an after hours push button for air conditioning. The first point is the time the alarm is first initiated and the second is the time the alarm is disabled after the after hours timer disables.

Below are the queries which I am using to retrieves...