SELECT GETDATE AS DTNOW datediff hh getdate EXVOYINPODDT AS HH EXPRESTUCTNNO EXPRESTUCTNOPE EXPRESTUCTNSZ EXPRESTUCTNTP EXPRESTUDESTPORT EXPRESTUCTNREF EXPRESTUEOYPLREF EXPRESTUREMARK EXPRESTUOPERA

var query = from exprestu in db.EXPRESTU join eoypl in db.EOYPL on exprestu.EOYPLREF equals eoypl.EOYPLREF join exctn in db.EXCTN on exprestu.CTNREF equals exctn.CTNREF join exdiscnr in db.EXDISCNR on eoypl.EXDISREF equals exdiscnr.EXDISREF join exmbill in db.EXMBILL on exdiscnr.EXMBLREF equals exmbill.EXMBLREF join exvoy in db.EXVOY on exmbill.EXVOYREF equals exvoy.EXVOYREF join worktb in db.WORKTB on exctn.CTNOPE equals worktb.CTNOPE where exctn.PROCESSID == "0" || exctn.PROCESSID == "1" && exmbill.DISCTNID == "W" && exprestu.CTNREF == "ctnref" select new { DTNOW = DateTime.Now, HH = SqlFunctions.DateDiff("hh", DateTime.Now, exvoy.INPODDT), exprestu.CTNNO, exprestu.CTNOPE, exprestu.CTNSZ, exprestu.CTNTP, exprestu.DESTPORT, exprestu.CTNREF, exprestu.EOYPLREF, exprestu.REMARK, exprestu.OPERATNO, exprestu.GYLNO, exprestu.PLSTUDT, exctn.SEALNO, exdiscnr.EXMBLREF, exmbill.CARAGT, exmbill.TRANLB, exvoy.VESCD, exvoy.VOYNO, exvoy.INPODDT, exvoy.JGSTDT, A = worktb.A, WCTNOPE = exctn.CTNOPE, exctn.PLATFORM, exctn.AREA }