tajo-core-tests/src/test/resources/queries/TestUnionQuery/testRightUnionWithJoin.sql

select * from ( 
  select a.id, b.c_name, a.code from customer b 
  join ( 
    select l_orderkey as id, 'lineitem' as code from lineitem 
    union all 
    select o_orderkey as id, 'order' as code from orders 
  ) a on a.id = b.c_custkey
) c order by id, code