SELECT a.PROCDATE,
a.HDT, a.DMC_HEM, a.CP_DU, a.EQPT, a.PROV, a.IS_EP, a.OOS, a.IS_TRBL, a.UNASGN, a.UNEQPD, a.COMMDOWN,
cp.INDICE, cp.ID, cp.CARRIER, cp.DIR, cp.PORT, cp.PB, cp.DIST_CHAN,cp.DS_CP, cp.C0, cp.C1, cp.C2, cp.C3, cp.C4, cp.C5, cp.C6, cp.C7,
dmc1.Primary_State, dmc1.Secondary_State, dmc1.DS_CHAN, dmc1.US_CHAN, dmc1.TX, dmc1.RX
FROM nvp_queryvp a
LEFT JOIN
(
SELECT HDT, PROCDATE, UNIT, HEM, Primary_State, Secondary_State, DS_CHAN, US_CHAN, TX, RX