SELECT A.ATRD_ID, A.ORD, A.ROAD_ID, B.IFSC_ID, B.ORD
  FROM TB_ATRD_ROAD_RLTN A, TB_ROAD_IFSC_RLTN B
 WHERE A.ROAD_ID = B.ROAD_ID
   AND A.ATRD_ID = 'ATR2001'

 
