select
f.a , f.c2 , e.Entrance_number, e.Exit_number,f.c5 , f.c6 , f.c7 , f.c8 , f.c9 , f.c10 , f.c11 , f.c12 , f.c13 , f.c14, f.c15 , f.c16, f.c17 , f.c18 , f.c19 , f.c20 , f.c21 , f.c22 , f.c23 , f.c24 , f.c25 , f.c26 , f.c27 , f.c28 , f.c29 , f.c30 , f.c31 , f.c32 , f.c33
from
(select distinct a.Entrance_number , a.Exit_number from all_OD as a) as e
left outer join
(
select * from
(select dx.*
, rq.c2
, rq.c3
, rq.c4
, rq.c5
, rq.c6
, rq.c7
, rq.c8
, rq.c9
, rq.c10
, rq.c11
, rq.c12
, rq.c13