So try

SELECT DISTINCT

t1.id,

t1.empid,

t1.jobnum,

t1.opcode,

t1.starttime,

t1.finishtime,

t2.id id2,

t2.empid empid2,

t2.jobnum jobnum2,

t2.opcode opcode2,

t2.starttime starttime2,

t2.finishtime finishtime2

FROM

vGSL_DMTEpicorData t1 inner join

vGSL_DMTEpicorData t2

on t1.jobnum=t2.jobnum and

t1.empid=t2.empid and

(

t1.starttime < t2.finishtime and

t2.starttime < t2.finishtime and

t1.id < t2.id

)

WHERE

t1.empid <>'0' and

t1.starttime >'2014-10-01 00:00:00.000'

order by

empid